Dave Grohl thinks he has blown the Foo Fighters chance of performing at the Super Bowl after he drunkenly told the organisers that he "didn't want to do it anymore".