Actually, in a busy suburb of a major city (London), my kids do NOT need ferrying about to friends, scouts and guides, swimming, the park. They walk, or go on bus and tube. They have walked to school alone since aged 9.
If you really want to do it, OP, then go for it and doubtless you will make it work. But I do note that in early teen-hood my kids have the freedom of the region, and go to different parks together, walk to local clubs, visit all sorts of events and have a hugely busy social calendar outside the family, my neice and nephew on isolated outskirts of a village spend far more time than my kids on the XBox, experience fewer events and cultural opprtunities and have fewer friends they socialise with outside school. They are not confident using public transport or visiting places they don't know, and while their parents do not begrudge the constant taxi-ing to dance lessons and scouts, it does take up a massive chunk of weekends - dance classes involve, for example, 2 x6 mile round trips. They have to run 2 cars. I am aghast at the petrol bills and conesquent carbon emissions of a family who purport to enjoy a 'back to nature' life.
My kids get plenty of access to the countryide - we walk, camp in rural locations, starwatch, badger watch, visit rock pools and ponds and lakes at holiday times and weekends - just as we would if we lived by them!
But as I say, you will make it work for all of you if it was what you really want. We all have to make comromises on something, just be clear about the various realities.