When I was about 8, @NewStartFamily, my parents decided to move us to a tiny village on the side of a hill in Shropshire, because they wanted somewhere with a big garden. It worked perfectly for them - they loved the area, mum had a massive garden, dad grew vegetables, raised hens for eggs, and got interested in local history.
I hated it. Dsis and I were sent to a tiny village school - 10 pupils in the Infants and 18 in the Juniors - where every single other pupil had known each other pretty much since birth, and we were total outsiders. I was bullied in the Juniors and then worse when I went to secondary school. It only stopped when I went to Sixth Form college, by which time the life long damage to my mental health and self esteem was irreparable.
We had no social life - there was no transport to or from the village, apart from a bus to the local town on Wednesday morning then home the same afternoon - during school hours so no use to teenagers. The nearest bus stop with an hourly service in each direction was 2 miles walk away, and the tickets were way, way above my pocket money. Mum didn’t drive, and dad commuted an hour’s drive to work, and home, so didn’t want to do extra driving at the weekends - so there was almost no chance of dsis or I going to a friend’s house, or a party or even a school social event. We were very isolated - I think dsis did have one good friend who lived close by, but I didn’t even have that. I spent my teenage years sitting alone in my bedroom, reading. It was horribly lonely and isolated.
It could have been better, if my parents had had any thought for the impact their decision to move would have on us, but from my point of view, all they cared about was getting their rural idyll. I think they just assumed we would be happy, and didn’t bother to check whether we were.
When dh and I were considering a move, from Essex to near Glasgow, with our three dses, we sat down with them and talked it all through, to make sure that they were happy with the move, and we made sure we picked somewhere to live that would be good for them as they grew up - good transport links, not isolated, a good secondary school, and a good sized community, so there would be plenty of opportunities to make friends.
This move might work for you, but please learn from my experience - think long and hard about what you are giving up for your son, and how much you will have to do, to support him in having a full social life and friendships.