I'm sure there are many factors involved. One factor many of them have in common is a simple memorable tune. However an obvious exception is out of Dibdin's thousands of songs the one that some people can still sing is 'Tom Bowling' which has quite a decorated arty tune.

Be careful in using phrases like 'a dreadful melody'. Remember 'one man's meat....'