When you build an arena (even for non mainstream sport), you make money off of taxing the Franchise, but more substantially off of the local businesses that opened up to serve the fans of the team. Over priced beer, food, and jerseys can make a lot of money if there's a well-liked team behind it all.
Plus, people LIKE it. It's a regional pride thing.
If you're an average guy, do you want to see three astronauts orbit the earth for 6 months, or go down town with your buddies, get drunk, and watch a game?
That's why the average guy votes for the new stadium over NASA.