Josh Brolin, Sean Penn, Nicholas Cage, Christian Slater, Mel Gibson, Mickey Rourke, Alec Baldwin, Wesley Snipes and yes even Terrence Howard
It's happened before and people still have careers in Hollywood. You could argue, and it's grim for some people, that Gibson was less held to the fire for claims of domestic abuse than for his "other viewpoints"
John Singleton probably only gets a pass now because he has a slightly hit show, Snowfall, that he created before his death. And, of course, he's dead now. So can't kick a guy anymore after that.
If it's a single situation and there are no others OR the others are quietly buried away, then I think Majors will still be viable for the MCU. Odds are that this was a timed release by Marvel. They knew it was coming and just got out ahead of the story so it couldn't be used later down the road. The Avengers films are far enough away in time where people will forget and move on and be enraged at other scandals.
The DCEU is trying that with Ezra Miller right now. Just waiting. Time for people to move on to the next thing. I'm not saying that's fair or right, but it happens.
Hugh Grant got caught with a hooker and like drugs in a car, and he simply "rebranded" into a more edgy bad boy character instead of the goofy bumbling innocent handsome guy who steps over all his own words.