There are smaller cities that are called one-company towns. One university, one army base, one large manufacturing plant. That is the largest and most prominent employer in the region. If that one thing goes away, the town will suffer. Remote workers are different because they can hedge that risk. So with more remote work, eventually, perhaps we'll start seeing new patterns emerge, it could revitalize some areas. If there is more talent gathering, a positive feedback loop might start...
Edit: To add, tax incentive structure can be important. Some states do a lot better in that regard. There are even special deals arranged like "If you move your headquarters here, you'll pay lower taxes" or something similar.