I can answer this with first-hand knowledge. Unfortunately. I have to agree that you will not be doing your son any favors. We lived in Mayodan, NC (about 45 minutes north of Greensboro). I loved the area. I loved the area and our land/house, but once the people realized we were staying, attitudes changed big time. My husband coached my son's little league team. The only people I was friends with - who wanted to be friends with me - were from New Jersey, Illinois, etc. Once the "native" (for lack of a better word) parents found out we were Catholic and I let my son read Harry Potter, all hell broke loose. I suddenly became a Damn Yankee.
I hear more times than I care to remember, "Damn Yankee! Go home!" I was also told I was going to hell for being Catholic. People from the local churches started showing up on our doorstep trying to "school" us in the right way to be a Christian. One group of people even had the nerve to stand right in front of my husband as he was on the lawn tractor, trying to mow our grass. They started spouting Bible verses at him and tried to debate the Bible. What they didn't know is my husband went to Catholic school from first through twelfth grade. He sent one lady in the group home, crying!! She couldn't keep up with him. "Christian" became a four letter word to us. Religion is sooooo much different there than in the North.
The kids at the school were horrible. My son came home with a black eye twice in the 6th grade. The report we got from the teacher was that he was walking in the hall to go to lunch. The kids that gave him the black eye jumped him and started calling him Damn Yankee. The teachers did nothing but give the kids a written warning and called their parents. These same kids rode the school bus with my son. They then told him they were going to kill him and our entire family. They went into detail about how they were going to do it and the layout of our property. (What we didn't know is we bought property that had belonged to a family for many, many years. The person we bought from couldn't pay the taxes and sold it. So, we lived right in the middle of this family.) The cops were called, restraining orders were issued. The school told us and our son we needed thicker skins and to get over it. It was miserable. We moved two months later to Chicago.
Another reason we moved was the fact the KKK was burning crosses in a front yard just half a mile from our house.

I have many more stories, but I'll leave it at that.
We also lived in Roanoke, VA for awhile. Completely different experience. LOVED it there.
Good luck!
Michelle
Edited to add - In all fairness, I'm sure we were the exception. We were in a VERY rural area of NC. I have cousins from NY state that live in Cary, NC and love it there. And, again, I would move back to Roanoke, VA in a heartbeat.