If the artist is still alive, then generally no. I don’t support any anti-trans artists because their beliefs and sometimes actions harm me and people I care about. It would be hypocritical and privileged of me to not apply that to artists that harm groups I’m not in.

If the artist is dead however, I’m a bit more flexible. A vast amount of historical artists were sexist or racist or bigoted in some way by modern standards. Not to mention the art the created may be constrained by the norms of the time as well. It would be extremely difficult to find a historical artist without something to take issue with and they’re not actively harming anyone anymore.