I’ve seen at least one article suggesting the end of centralization into cities. I suspect LEO based internet services will further help people move back to the country. All that’s needed is work out there.
A friend lived outside a city of 20,000 in rural Colorado. He dropped $10-20k to get fiber run out. It seems like a lot, but If that's literally the only thing keeping you from moving from the Bay Area to a small town, you just haven't done your research.