I generally agree - like with NIMBYism its mostly a case of bad incentives created by dumb government regulation, combined with the natural selfishness of people. Sports leagues have an antitrust exemption that allows them to abuse their monopolistic position in society and since there are only 32 NFL teams they have a lot of leverage to extort cities for stadium funding. The fans don't really care as their share of the tax cost is small compared to the benefits they get from it, and politicians know they will pay a high political price if the team leaves, but probably not if they waste a bunch of tax dollars to keep them there.
So it's basically a situation where bad government regulation leads to a situation where it's individually rational for all these different groups to do something that hurts society as a whole. Greedy owner gets a lot of money, sports fans keep their team, politicians get re-elected, everyone else gets screwed. It really is just like NIMBYism for housing!