Ravel's "Bolero" contains, when you simply hum it without the accompanying harmonies, one of the worst melodic lines I have ever heard, sounding banal, contrived, and all those other words referring to something negatively. Yet when you actually play it with the music ... you get something remarkably less awful. (I happen to think it has a certain charm, but it's not everyone's cup of tea.)
I suppose with lyrics, it's similar. I think it was Voltaire who said "Song lyrics are words too stupid to be said", or something to that effect, but when you put them to music, Ah!, now it becomes involving and artistically meaningful.
Or, of course, the lyrics can be forever terrible no matter how you slice them.
My humps, my lumps, my bumps.