Perhaps, but the taxes are usually focused on tourism (hotel and auto rental taxes), which is the sector that is helped the most by new stadia.

Also consider the loss of business that happens when a team leaves, such as when the Seattle Supersonics left for Oklahoma City. Even if there isn't a net gain for building a new stadium, there may be a local gain at another city's expense, such as between Seattle and Oklahoma City.