Officials thought there would always be huge demand for affordable housing, so they aimed to maximize it for the working class. But now those units are vacant.