Anecdotally, my Bay Area friends are all excited about the prospect of decreasing pressure on their cities.

Plenty of people still want to be in the Bay Area. The previous situation was far too oversubscribed for the amount of space and housing available. Release some of that pressure and the city could become more attractive again. They will still need to solve the crime issues, though.