It does generate revenue that otherwise would not be realized.
Well it may bring some revenue to your state that might be spent elsewhere without it. But I doubt it is very significant.
“It does generate revenue that otherwise would not be realized.”
Not really, the revenue just shows up in different accounts, thats all.
No difference in hotel occupancy rates, restaurant attendance, airline arrivals, etc.
Atlanta is sold out every weekend of every year, SB or not.
Revenue, yes. Profit, not so clearly.
Putting on the game takes a lot of money - security, infrastructure, perhaps even building hotels or the like.
Some places have a windfall - likely established bars or restaurants.
But, overall, I have seen a number of studies that indicate that the net influence economically is neutral or negative.