I think you missed the point. An average person may hold their alcohol and operate, but we don't approve cops being drunk on the job.

Huang betrayed 38 years of trust his wife put into him and recently betrayed the Board by lying to them. That's already admitted, no ifs or buts. He clearly had reasons, as he is a sane person. His reasons were romantic engagement with (alleged) spy. Since he is a sane person, he must have weighed pros and cons and still engage in an affair, even though it jeopardized his marriage and his job. The Board needs to do bunch of "what ifs" in such situation, including paranoid ones, such as "what if this woman had such access to NVIDIA tech stack that each cheap is infused with some form of Chinese virus". We simply don't know how far this goes, but this firing certainly shows much further than just a consequence of a romantic fling.