It wasn't the snow weight that collapsed the Metrodome roof. It was the Green Bay Wizard. Watch the video.
http://www.youtube.com/watch?v=Jjig55OeEi0