the footage is from a SNL skit - but I think the Night at Roxbury was based on the skit/characters/or the song was just in the movie with SNLcharacters/actors.
I don't know about being the greatest of 07, but this one is the greatest of ALL TIME. I don't care a single bit about hockey, but the 6:07 mark givesme goosebumps, and the ending is perfect.