California is a big state. Surely this only bans single family zoning in egregious areas like San Francisco and not other parts of California that don't have a housing crisis?
The bill also doesn't eliminate single family zoning everywhere, things like no sewers (so have to use septic) still apply to necessarily reduced density.