In the US, it's always election season, so political cynicism doesn't rest either. But do note that while state politics are largely single-party, local municipalities are much more varied (California, like the rest of the country, is an archipelago of blue cities in a sea of red). Rest assured that this hardline approach will be the norm throughout much of the state even if SF doesn't swing hard right overnight.
Even blue cities have variation. Witness Seattle’s left wing city council getting decimated in the last election with largely moderates replacing them. Within a city, you have moderate districts of mainly home owners and more left wing districts of mainly renters.
I would argue that California really isn't that progressive even in the blue cities. And when things get really progressive, like with SF's school board, voters take it back. Actually the SF schoolboard election where non-citizens are allowed to vote probably helped that swing, since Asians and Latinos (more likely to lack citizenship) are more conservative on average (try telling a Chinese parent that math is racist...).
Back when I lived in Portland 20+ years ago, just as it was starting to turn into the version of itself that would be sent up in Portlandia, I used to tell relatives back east that culturally Oregon is to California what California is to the rest of the country.
Not sure how true that remains these days, it's been a while since I've been up there.
Yeah Los Angeles (just the city, not the rest of the county and other municipalities within) is one of the only places actively not complying with the EO