I’m not sure they are parodies of a specific movie or moment - they might just be parodies of tropes, things that everybody has seen on TV at some point.
That’s referring to a particular guy, Frank Nelson, a wonderful character actor. You may have seen him in such shows as I Love Lucy, Sanford and Son or The Jack Benny Program.
I don’t know if it’s this, but one very famous ‘Noooooo!’ is the one uttered by Luke Skywalker when Darth Vader reveals thatRosebud is the name of his sled
-you can watch the clip here:
And an excellent take on it from Toy Story 2 here:
I’m usually very well behaved in movie theaters, but at the end of Crap Prequel #3 (I’ve long since forgotten the title) when Darth stands up, shakes his fist in the air, and yells “Nooooooooooo” I freaking lost it. I was laughing so hard, it made me sick.