But isn't that what our society does these days? Or at least certain segments of it.
They take someone who is X and then elevate them to some unreasonably high status that no one person should attain, and then that same society drops them like they're a hot potato when they find out that the person isn't perfect.
To be clear, I don't disagree with your take. We shouldn't be undermining someone's work because of some stupid opinion on this or dumb decision to do that.
But think about what's become a rather popular event over the last couple of years. Some actor gets shunned for saying some stupid shit about vaccines. There has been a whole rash of events where statues of people long dead have been taken down. Buildings dedicated to certain people were renamed. Columbus - the poor guy's legacy has been dragged through the mud because of people who can't separate the fact that he was a great explorer but he was also a bit of a douchebag.
We need to stop elevating these people to the level of a deity, and then we won't be shocked to find out the person was just human and a bit of a womanizer or a prick about money or he didn't like certain groups all that much. Praise them for their singing or acting or the new world they explored.