I feel like I got served an appetizer and a small dessert, with no main course in between. California has a housing crisis in some cities. Californians are moving out of those cities. The cities that they're moving into are experiencing an increase in demand (directly restating the previous). That's pushing up prices (not shocking), which is preventing some people with less money from outbidding people with more mone…
California was short on both types of housing - what has changed is that it is in even higher demand now! And if remote work continues after COVID, that will continue.
Add to that more efficient electric cars + more self-driving capabilities, and I think the demand pendulum will continue to swing back towards sprawl.
You also have a bunch of millennials still in child-bearing age ranges who are getting around to that.
You won't fix a single family home demand surge by replacing single family homes with other things.
"How will we make sprawl work better than it has in the past" seems a more useful question.