Of course, this is just my own theory based on my own, personal (and therefore anecdotal) experience. For example, to enjoy a song, I first need to like its music. If the lyrics are in a language I understand, then I need to like them too, but I'm more forgiving in that aspect. I've always thought that this is because I have a rather decent ear. Even though my voice often lacks the capacity to reproduce the music correctly, I can distinguish sounds well enough that I can reproduce at least the main melody on a keyboard.
On the other hand, I've noticed that most people who have less-than-decent "ear" tend to focus more on lyrics than on music. My theory is that if you can't distinguish well enough one melody from another, your won't be able to enjoy songs based on their music -- it's sort of like expecting a blind person to admire a painting.
I think the weakest link in my theory is the fact that I'm basing it on my "anecdata": among all the people I know, those with "not-so-good ear" are more frequent than those with "decent ear". It would be interesting to see what other people's experiences when it comes to that.