I think the alliteration is what makes it a good insult fundamentally - it feels satisfying to shout in frustration: "Quit your obnoxious yapping, you absolute wankwaffle". I'd assume it also implies self-important ego-stroking nonsense? "Get to the point, life's too short for this wankwaffle!"