There’s amusia, which is “tone-deafness”.

It’s one thing to not sing in tune or not remember a melody correctly, but there are people who can not even hear a difference between two melodies, even if they can tell other sounds apart. I would guess that’s somewhat similar, because I doubt these people have any chance in imagining what a melody sounds like.