I think I'm in the minority with this position but I'm gonna roll it out anyway.
I think a bad weather Super Bowl is an awesome idea. Why is the "Ice Bowl" such a legendary game? Because of the beautiful weather and perfectly manicured field? I think not.
I think the media is leading the charge against venues like Met Life Stadium because they like the perk of going to a warm place every February and mixing vacation with work.
Granted, 100,000 or so fans could be inconvenienced by bad weather that week and on game day. They won't be able to golf and stroll around Manhattan in shirt sleeve.
Compare that to the 3 billion fans world wide who will marvel at players and coaches having to deal with one more significant element on the way to the Lombardi Trophy.
One could say that cold weather gives an advantage to teams from the north. Well doesn't warm weather advantage southern teams who are used to dealing with heat and their bodies are more acclimated to that?
I think that if the goal is to give maximum enjoyment to billions of fans watching the game, the potential for bad weather adds an exciting element of drama which is good for the sport. But that's just me.