I agree, this type of solution is 'trendy' and 'innovative', but is not a real solution to the Bay Area's housing problem.
We do not have a space or money problem, we have a legislative one. Building height limits, NIMBYs and other laws affect how many homes are built. We have plenty of space in the sky to build 12+ story buildings for housing, but we don't.