I agree with you that it's a complicated issue with no right answer and I don't think that warrants the total destruction of the piece of media in question. And I don't think you meant that it did either, but it seems that people think you did.
This situation reminds me of the old episodes of Mickey Mouse (Steamboat Willy? I can't remember the exact cartoon the episodes came from, if they even came from a specific series at all and weren't just one-offs) where Disney has a disclaimer on them if they're ever shown anywhere about how they are for archival purposes only and that they reflect the views and culture of the time that they were made in, and how that doesn't make those views okay. Because they're super fuckin' racist cartoons, like full on black people = monkeys racist, and Disney knows that that's not okay (more like they know that showing that would lose them money at any rate), but that doesn't mean that they're not worth preserving so that we don't lose sight of what the past actually was like and allow people to slap rose colored glasses on the "better days" or something.
As others have mentioned too, it also depends on how the depiction is used. Like when there was all that outrage over the Cyberpunk 2077 Chimaera "Mix it Up" posters of the girl with the giant "package" under her one piece. Yes, those posters are gross sexual objectification and horribly transphobic, but that's the point. They're intended to show how fucked up the dystopia of 2077 America is and how advertising has always used sexual objectification to sell products, and if a company thinks that using trans people's bodies will sell a product, they absolutely will. Just like they do every year with Rainbow Capitalism during Pride.
There are times when the destruction of something horrible is absolutely the way to go, like when Germany destroyed all the Nazi statues right after WW2 and put a memorial to the victims of the Holocaust where Hitler's bunker had been. But even then, it's vital to preserve that past so it can't be washed away. The Germans also took photos of the statues they destroyed, to preserve it so that something like that can't happen again. We can't learn from our mistakes if there's no evidence that they even happened.
Reminds me of how something like 60% of video games only exist as emulators, because companies never bothered to preserve them in any form. There was even a remake of a game in the past few years that still had the Skidrow logo in it, because the devs had to go and torrent a pirated copy of the game since the original code was gone and they forgot to remove the cracker's logo. There was also the infamous GTA remake that was made from the phone version of the game for the same reason.