Exactly. The residents could vote to build more shelters or do something/anything realistic to solve the homeless issue (other than just giving them money/tents/needles), but if they build more homes then that increases the supply of homes which residents are fundamentally against. They don't want any new housing to ever be approved for any levels/neighborhoods because by restricting supply it pushes prices up.
The people in SF like their million dollar shoeboxes to appreciate in value, with zero regard for the externalities that scheme creates[1].
1. https://www.pewtrusts.org/en/research-and-analysis/articles/...