A few municipalities will resist, but I'm not optimistic that the free money for rich people who own sports teams era will ever end. For reasons I don't quite understand sports have a weird place in our culture. The public doesn't seem to get too upset about these deals. They might not always be popular, but they're more popular than losing the treasured sports team, though those leaving the city threats are often not credible.
Done right, baseball especially can deliver some benefits (which is not to say that those benefits justify massive public subsidies), but cities that throw cash at football stadiums are corrupt and/or stupid.