I imagine "housing first" works best when there is any housing to have.

SF, like much of California, has refused to build housing for half a century, while the population has kept increasing.

To house a homeless person there, someone else pretty much has to move out.