One part trustworthiness, one part likeability, one part risk aversion. Some companies have very unlikable CEOs but they are otherwise effective enough to get by.
In this case, Huang hit all three. Changing CEOs is also a good way to get the media coverage over faster, or at least change the narrative in the pubic (and investors) minds.
If it were just an affair, I doubt he would have lost his job. It wasn't, though, and the other circumstances- potentially dodging export controls and abusing a role of power over a subordinate- came with far too much heat, so to speak.
Also, affairs make for much more entertaining gossip than the other items, so it's probably natural that that aspect gets talked about more.