The president’s expected attendance at Sunday’s Super Bowl highlights how his connection to the league has veered from aspirational to openly antagonistic.