I don't think this is going to be true in the longer-term, and clearly SF has an exodus underway (https://www.sfgate.com/expensive-san-francisco/article/Bay-A...). People will (are?) realize that the benefits of SF are not worth the tradeoffs (if their circumstances are such that they can't make it there), and move elsewhere. They might (should?) make their way to many of the inexpensive cities away from the coasts that are more affordable, and the new residents moving into those cities will help make them vibrant cities.

At some point, the incumbent residents of SF or other communities may change their policies if what they desire is different. Or not.

But I don't think there is any lack of housing supply or jobs in the middle of the US. What is lacking is the exact housing people want, at the exact price point people desire, at the exact locations they want to live in, in the line of work they want to be in. Demanding such an exceptional situation is highly unreasonable. Making tradeoffs/compromises is a part of life, and no one is entitled to have the best on every dimension by default - that has to be earned.