While sports teams are often touted as economic boons for the cities that host them, Zimbalist said the reality is less optimistic.