Yes he could have been targeted by a foreign intelligence agency. That's a government problem to investigate.

The board would be more concerned with his conduct as a CEO and whether he's still best to lead the company.

Having an affair didn't happen to him, he presumably was fully aware of what he was doing there.