I don't think "increasingly unaffordable" and "acceleration of out-migration from cities" can realistically happen at the same time. I can definitely say that London's (where I am) population is growing, and grew consistently through Covid. A quick Google tells me NYC, Seattle, Chicago are all adding people at comparable-or-greater rates than the US population is growing.