Rumncoke's recollection is of Sidney Carter's "Mixed-up Old Man".

To address Leeniea's point, albeit belatedly, there's no end of comic songs about things that in real life are not funny in the least - unwanted pregnancies, alcohol abuse, industrial accidents, marital infidelity. But people seem happy to laugh at the imaginary misfortunes of a fictional person invented purely for that purpose.