Technically that doesn't mean they were bad at the time, that just aged much worse than the other bands you mention, so depends whether you rate them in context of their era or in present day, some things age bad, some age good.

To me they are like Citizen Kane: it’s a great movie because what it did had never been done before but I have no interest in watching it ever again.

Funnily enough I share same sentiment about Beatles as about Citizen Kane, I forced myself to watch it together with Casablanca and few other "classics" and it's horrible movie by nowadays standards and I'd say you don't need to see it even once unless you are really movie nerd.

Back in the day it was revolutionary and important I guess, but by nowadays standards it's utterly mediocre movie despite people praising it as something amazing, but to be fair I don't think I'd find movie from CK era which I'd like while I have no problem to find better artists from Beatles era whose music I enjoy much more and like them even nowadays compared to present day music.

And one more unpopular opinion from someone who experienced jail like environment I think even recent highly rated Shawshank redemption while very good and enjoyable movie is romantic unrealistic fairy tale (for women) and I'd rather recommend everyone to watch Das Experiment to see more realistic display of prison I can sign, yet I've of them is rated asking best movies in history and the other is pretty much unknown.

It maybe says something profound about the nature and universality of music vs the relative recency of movies as an art form. Music can be understood and enjoyed more universally. We can listen to music in languages we don’t know and thing it’s great. We can rarely watch a movie without any cultural context and enjoy it. Also movies as an art form have had to evolve fast over their short life, but music has existed for millennia. As a result perhaps old movies age out much quicker because movies need context but music can transcend time and context more easily.