“It’s an honour of a lifetime to finally check a Super Bowl performance off my bucket list,” Usher said