The situation, AFAIK, is that Glendale is stuck for a lot of the expenses surrounding the SB itself since the stadium is in its town, but that the bulk of the revenue is going to Phoenix, since that is where the fans are staying, and where the runup events are taking place. (P.S. My son lives in Tempe, on the other side of Phoenix from Glendale, and he wrangled a business trip to Denver in order to avoid having to work downtown this week.)
Works for us in Scottsdale - we get all of the tourist cash and none of the headaches. :) But the Phoenix Open is going on this weekend, too - so we still have way too much traffic.