So a real estate bubble hits, home owners are hurt, and the government gets used to what they think is the new normal. The government takes on wasteful obligations, hiring lots of people and failing to push back on pension demands. Once the bubble pops, the city budget is in deep trouble. Something must be cut. It isn't easy to lay off employees and cut back the pensions, so the city increases the tax rate.
Repeat that again with a new bubble, again and again, and the rates only go up. It's a ratchet effect, with rates going up but never down.
Voters chose a simplistic way to put a stop to this problem. Something was needed, but the chosen solution is pretty bad. The fact that people can't trade houses without seeing rate increases means that people commute too far, clogging up the roads. Newcomers also get hit, with cities imposing huge impact fees and generally discouraging housing because the housing doesn't pay for itself due to Prop 13.
What was really needed was a restriction on the total city budget. Instead of setting a tax rate and then calculating the budget, we could set the budget and then calculate the tax rate. Applying the restriction to the total city budget serves the necessary purpose of putting a stop to out-of-control spending.