Not only are they classic Picard moments, they usually happened when other people started taking over the song, so it was as though Picard was saying "No, Number One, the title says that Picard sings Let it Snow. Stop that."

Moments where Wesley is told to shut up are the favorites of a lot of people. Which reminds me of another video. It's also not a song, but it's still very enjoyable.