Where ever you decide to bring up your children and lots of people don't have a choice, they will be who they are. If you have a choice and give them opportunities to experience a different lifestyle, culture, environment etc which enriches their upbringing then how great is that! Later in life they will make their own choices.
I was brought up in small, rural community. One other child in the village until my sister came along when I was five. My son was in a similar situation 20 years ago. He is social, hardworking, practical, appreciates the countryside. I took him out of mainstream school at 14, it wasn't for him. I was told he'd lose contact with his friends and miss out on lots. He has masses of friends and missed nothing. He is self employed and doing just fine.
Today the world is a smaller place with social media but if you can have that and fields, freedom, animals and understand where food comes from, how things have to pay for themselves and that material things aren't always necessary then the positives in my opinion outweigh the negative stuff.
One of the biggest drawbacks of rural locations has to be the sketchy provision of public transport. It puts more pressure on parents to be a taxis. And your children will need/want to drive as soon as they can. Bit of a scary time for any parent but with possible driving curfews for new drivers etc I think this will become an issue for young, rural adults and families.
My son biked to the next village at about 8yrs old. You teach them to do things safely. Like when you shout "move" because the sheep are heading their way you mean "move now and ask questions later"!
You will know when you find the right place.
I would say that you need to think very carefully about how far you move from family. If you need them or they need you, long distances, especially if it going to be over an extended period, gets expensive, tiring and stressful.