My father was military, so we moved ever couple of years. My mom is from SC, and my father is from PA, so we never really lived near family.
Like Kimberley says it takes time, but soon it will be 'home' to you. With children, you will have the opportunity to meet other moms and I bet you'll find that they are more than willing to 'share' their community with you. Just ask lots of questions. People love to tell you their thoughts on where to find the best restaurants, barber, shopping, gyms, etc.
My family (because of my mom) always looked at each move like a new adventure and she would always stress the positives, so I learned to like the changes. Help your kids look up information about Concord and NC so they will know what to expect. (My mom would have LOVED to have had the Internet when we were little-we just went to the library!)
Kids adjust fast, just try not to let them know your fears about the move. Trust me, they'll smell your weakness and use it against you later!
Good luck!!
BTW-That's a lovely part of the state!