If my memory serves me right you see the superdome off to the left of the freeway as you come into the city. I think it's on the other side of downtown from the French Quarter.
What happens to the New Orleans Saints? First home game is Sept 18 vs New York Giants. Doesn't look like it will be at the Super Dome.