Honestly, the housing cost is a severe impediment to people with families, unless companies decide to adjust for this in a real manner. But, the moment they do, pricing/rents will go way up.
The only real way to solve this problem is to not try to bring more people to the Bay Area. Defuse the rent seekers. Reduce the tech mediated inflation.
I don't think this will happen on its own. You'll need a crash of some sort for the area to find its real prices. And it is alarming talking to the recruiters, whom seem to think that housing prices will only ever go up.
This communal living is IMO, a symptom of the problem. It is not a long term solution. I don't know what is the solution. Though I should point out that there is a whole rest of the country which is relatively open ...