Yeh SF isnt really representative of most cities in that sense. Even there, the only year with a significant drop was January 2020 to January 2021. SF has big barriers to building houses which creates all kinds of problems.

Some cities will stagnate, some cities will grow strongly but no cities are heading for big population drops except for places like Japan where the whole country is disappearing. Even there it is the rural areas that are becoming depopulated first. That is a much stronger trend over all and we are going to see much more of it in a lot of countries.

Well, we wont see it in person because we wont actually bother to visit those places but statistically it will be recorded more and more.