My favourite artist has been cancelled! What do I do??
I think this is the wrong way to address the issue. Rather than cancellation, we need individually to decide how the scandal, statement, or other controversy colours the work we love, and in what shades. For some people, the metatextual knowledge of the artist will be overwhelming, and they won't be able to continue to consume the work. For others, it will just be another thread, however distasteful, on top of the themes and interpretations that were already present in the artist's art. For others still, it will have no effect at all, as they don't inject that commentary into the text at all. All three are equally valid.
There's a fourth group, of course, which is particularly social media prone, who enjoy feeling morally righteous by ceasing to consume the work of people who've been cancelled. I know because I spent a lot of time thinking that way. If you're one of those, I'm sure you'll be tempted to reply, but I'm not talking to you. So we'll leave door number 4 for now.
What I would suggest is that you go back and consume the art that you love and see how much you read the current scandal into it. That will tell you how much you're still able to enjoy the work for what it was to you a month ago. It might be that falling into those old, comforting flows of language or colour of music allows you to put the real world aside as you fall into it. It might well be that it's time to find some other artist who speaks to you in a similar way. Even if you return to that artist's work some day in the future.
Whatever you choose to do, I'd say take a break from the discourse here and on other social media and make your mind up for yourself. Ultimately art is a conversation between the artist and the consumer. Everything else is just noise.
I've put in the tags the artist I was thinking of when I wrote this, but I really do think it applies to any artist; including ones that I personally find loathsome, such as J. K. Rowling or Morrissey. Your relationship with art is your own, and don't let anyone else shout you down.