Football’s biggest show kicks off next week and the US president means to be its biggest star. But prestige-hungry hosts do not always get their way