I don't think they would care much about the infidelity, but banging a report and a geopolitical enemy is a pretty bad idea overall. I don't think people would have been so surprised if a LockMart C-suite had been voluntold to resign after having an affair with a KGB-linked Soviet woman. And with a direct report as a cherry on top.

Gates had affairs with two Russians, nothing happened. He also had ties to Epstein and Epstein knew about these affairs, so he had huge leverage if needed.

Google execs had affairs, I think Sergey Brin had an affair with an employee, again nothing happened.

Gates had affairs with Russian prostitutes, and well after the end of the Cold War; not with Soviet IT businesswomen that might have been linked to the KGB.

And w.r.t. Brin vs. Huang, Rosenberg was a comparatively much lower ranked employee that didn't have a stratospheric carreer.