As it stands now outcomes vary wildly. Some people like Kevin Spacey were literally erased from movies that were already filmed; some others have just claimed back their place (maybe not their peak fame) on their own like Louis CK. And then there are neutral outcomes like the one you mention.
And then there's Jussie Smollett who isn't a sex situation but was caught in, uh, something that's not a good look.