I’ve heard this explained before as the selfishness of believing that if you’re protected on a local level, that frees these voters up to vote for other conservative policies on a national level.

That sometimes with these ordinances, they work the other way. If moderate voters pass the statewide protection, it allows them to rationalize a vote for Republicans to do immigration measures and tax cuts, because they feel protected by the state amendment.