Sleeping with your neck arched through the night can lead to pain in that area, which is why it's a good idea to experiment and find the best neck pain sleeping position for you.  Likewise, all that tossing, turning, and moving around we tend to do when we sleep can further cause or exacerbate existing pain.