The first affair was possibly survivable, although the cost of survival would be high for all involved.
The second affair was fatal to Jensen Haung. An affair with a direct report is generally a no-no in modern business and would have opened Nvidia up for all kinds of liability issues if they knew in any capacity. If he stayed it would have made a mockery of their code of conduct rules and opened Nvidia up to further legal issues.
Musk has survived and brushed off much worse.
And Jensen isn't just any CEO, he is the founder and has run the company for thirty years.
He would have survived the affairs if it wasn't for the export control violation aspects.