Zoning is up to the city so it chose this. SF does not need public housing, even 1 million dollar condos in a high rise would help.
Remember, people often have limited understanding of impacts focusing on a small percentage of what’s going on. Aka sound byte politics, a stadium is only half the story rarely used, low density parking can be a larger issue.