I find his situation fascinating and funny, mostly because he is an unpleasant person whose actions have led to his own humiliation, and his efforts to 'fix' things only ever make it worse. I think that for me, the one thing that would make me feel some sympathy for him would have been if he hadn't been such an obnoxious and mean person for so many years. We will root for people who fall, even when it is their own fault, if we feel that they are generally good or nice people. But we will enjoy the downfall of people who are arrogant and mean to others, especially when it is their own fault.
For Evans, the issue is that he appears to depend primarily on the support of people who subscribe to his Patreon and who donate funds when he requests it. They are the ones who are likely very offended by the fact that he cheated. Some may be unwilling to support him for the act of buying sex, but I don't think that it would have sunk his efforts at fundraising by itself. I think that the issue for many of them is that this was an ongoing behavior from a married man with two children. Aside from the moral concern, there is also the worry that he might give his wife an STD. There would also be the concern that, if caught, he might end up in prison. Not so easy to make videos moralizing against a cult when you're locked up for a month or more.
But for me, he's mostly just entertainment. His approach to this problem has been to fight back and go after anyone and everyone, because it enrages him to think that they're enjoying a bit of schadenfreude over his self-inflicted wounds. So he keeps stepping up to the public stage to try and salvage the situation, only to make things worse for himself. If I didn't know better, I'd say he was working on a sitcom.