I live in a 50K-population city adjoining Boston, so they exist, I just don't know how well they exist independent of bigger cities.
I live a few miles from pavement, so I definitely need a car to go anywhere. But I don't need to go anywhere on a normal day. I go to the nearest city about 3-4 times per month.
I do take advantage of UPS deliveries a lot, but I could do without if I were more patient.
I've set up my life to not need a daily commute, but I haven't taken the car out of it. If I tried harder, I could probably go without the car, but I don't think that would be healthy (Amazon Pantry options are lackluster last I looked).
To reiterate, I'm not even close to a paved road, let alone a grocery store or city, and I can manage not to drive very often. Seems like you could too, if you made it your focus. But we've all gotten used to living a few minutes from this and that and so we have to go do something, in our car, nearly every day.
Here in Ithaca NY, the property market (relative to income) is ungodly expensive, because most people either bought their houses decades ago when they were affordable, or they're college students who will pay any price in rent to get their quality education.
Some people commute in from as far away as Syracuse or even Pennsylvania. Property prices are much more affordable 15 minutes drive in any direction, but no college professor or staff would want their kids going to any of the crackerjack rural schools.
Can't say I speak for the Midwest, so it could be different there.
I'm married and have children - but we homeschool them, so the quality of the local schools is not a limiting factor.
Healthcare is not nearly so different even in very rural areas as you've made it out to be, especially not when you have a tech salary to enable you to travel to a teaching hospital if the need arises. If anything, regular/preventive care is less expensive and higher quality with a rural family doctor.
Uber and Lyft don't even make sense in a rural setting.
My professional network is already spread across the country, so that's not really an issue. I plan to spend more time and money on travel for conferences and such.
The only things we're really giving up are faster Internet access (we'll have 300Mb for ~$100/m, instead of 1Gb included in our rent) and food delivery services (which are too expensive to be using as much as we are, anyhow).
I grew up on island in Alaska. Completed my last two years of high school in a small farming community in North Carolina. Joined the military and after ten years separated from southern Turkey, yet, somehow I was able to land a job as a data scientist.
I joined the military due to a lack of academic discipline though I still was accepted to the state schools in North Carolina, just choose otherwise. I have friends who did the same, though one did attend Chapel Hill on academic scholarship he received while graduating in Alaska. I have another friend who is now an anesthesiologist who graduated from University of Washington's medical school.
A few remote workers will do wonders for rural America in the short and long term. Saying you need to live in a major city to be successful is hogwash.
If you answered yes to these questions, you're not going to find many places rural America that satisfy your needs. At best you'll end up in an outer-exurbia like greater Atlanta.
I don't think remote work of a few well-paid professionals is a viable and sustainable solution for rural America.