The Kansas City Chiefs tight end said it would be a 'great honor' for the President to attend the Super Bowl