The revamped Superdome is set to host its 8th Super Bowl after half a century of memorable moments