The move by cities to ignore it isn't surprising because metropolitan areas have a pretty significant non-profit industrial complex in place to grift off the less fortunate. All those NGO $100k/yr jobs in middle management would disappear if anything more than adding cots to FEMA trailers was ever implemented. Maybe I'm oversimplifying, but local officials also get points from their neolib constituents for defying the order.
More rural places in CA, like small towns along the Santa Maria Riverbed, worry me. I've heard many folks talk about inhumane or even violent solutions to the homeless encampments throughout those areas. I remember the stickers that started appearing on trucks after 9/11 - the terrorist hunting permits. It wouldn't surprise me if locals took things into their own hands as a reaction to the governor.