Probably. I loved touring the US parks while doing remote work, and I miss the freedom of being able to wander around anywhere and sort of ignore roads, but I wouldn't have been able to live in many of the areas that I adored.
One thing that people underestimate about the US is its vast size. When you live in a city, you have at least a dozen grocery stores within an hour's drive. When you live in a rural area, you drive at least an hour into "the city" which has a Walmart and a Kroger.
There are exceptions, like Utah which is basically one giant city/suburb/church running along the Great Salt Lake with a half-dozen national parks to the South. But I would lean towards this being a temporary trend for most people.
yeah, "the grass is always greener". I grew up in a small country town, it has its charms but it gets old too. By the time I was college age I left and never looked back. Small time life comes with a different set of problems than living in a city but they're still problems.