“I don’t know how to reconcile that my favorite piece of media was made by someone awful.” Because they’re a shitty person who made something good. It’s not that rare of a phenomenon. Shitty people make good things everyday. A piece of art being made by a terrible person does not make its effect null and void and making good art does not redeem a terrible person. People who are irredeemably nasty can say something true and honest on occasion. To reevaluate a work after finding out more about the artist’s horrendous biases and actions and still find things that are honest and true even when consuming it through a critical lens, that is a beautiful thing. If the artist’s actions and words completely destroy it for you and distort the meaning you once found, it’s okay to feel a sense of mourning and loss at that.
This is not to say that you should continue to lavish social and financial capital on the artist because you enjoy their art but to say that enjoying art made by horrible people does not mean you are in some way unclean.