Obviously, remote jobs are less plentiful than on-site jobs. Jobs in small municipalities are less plentiful than jobs in dense urban areas, for software work and most other types of work. Jobs tied to one single, small municipality are pretty idiosyncratic and don’t change that much (with employers uprooting and leaving being the most common type of change).
There are many reasons why living in smaller towns or rural America can be a great thing. Diversification of employment risk factors is absolutely not one of them, and this is an aspect of working remotely while based in a rural location that carries huge risks.
Also, as I wrote in another comment, escaping to the country doesn't need to be the back of beyond. The Bay Area is somewhat different because of geography but there are many cities with a reasonable number of tech jobs where you can drive 45 minutes and be in a relatively rural environment.
Personally that's what I do. I'm mostly remote and live in a fairly rural town but I'm within an hour of a major metro and I even commuted into the city for a while.
Taking a remote job when you already live in a city or when you live within a reasonable drive of some other job center would mitigate a lot of the risk I am describing. I am only talking about specifically using a remote job as license to move to a highly isolated, rural area not within commutable distance to a big job center.
The OP and other comments seem to describe this as a wholly positive ideal, and in many ways I can agree. But I felt an important part of the discussion is that if you use a single specific remote job as license to move to e.g. rural Wyoming and live on a ranch with DSL internet, you're setting yourself up for trouble, because it's actually not easy to find a new job in a pinch like that.
Own a place? Even if you find another local job, there's no guarantee that you'll like the new commute.
But you live in the Bay area you say and can get a new job on your lunch hour? Maybe. Maybe not. And you're paying a huge housing premium. Nothing against the Bay Area if that's your preference but spending a huge chunk of take-home pay on housing carries its own risks.
And maybe an opportunity comes along that's so compelling that you'll be willing to relocate. Lots of people move around for work. Just because you work remotely doesn't require you to do so forever.