Funny this is cancel-worthy sometimes, and in other times it's treated as a quaint personality trait.
Also, the Beatles aren't famous because I Want to Hold Your Hand sold 12 million copies. The Beatles have 50 multi-million selling singles.
I think it was mostly because he was such a self-assured prick though, and so it was easy to pile on.
But, it is clear that the inability for people to take responsibility for their actions and instead blame some bogeyman like "cancel culture" is a big problem. Enablers and others who make excuses for them are part of the problem too.
You can see this same tension in Fela Kuti fandom and scholarship, where people almost have to choose between lionizing him as a anti-colonialist or anti-dictatorship hero and downplaying negative sides so that his sociopolitical impact feels more powerful, or deploring his treatment of women as something that tarnished his whole career.
Yeah sometimes you see that in passing. Some famous people seem to get a pass especially if they are not polarizing nor brazen, as opposed to, say, someone like Donald Trump. But in the end, they hurt and abuse people all the same.
For example, almost every bio I've seen on YouTube about Richard Feynman treats his proclivity of banging his colleagues' wives as nothing more than some charming quirk or idiosyncrasy (usually to differentiate him from the bookish physicists of the time) at best, and a peccadillo at worst.
The worst description I've read yet of his behavior was summarized as: "he just loved women."
It's messed up.
Or Golden Rule too. I don't think any of us would want to see our wives agree to get banged by some other dude. Even if it was Richard Feynman.