Being drunk at the bar/club/social event and telling that very interested lady a bit too much is probably the better example

Still not as bad as being susceptible to blackmail or bribes

That is not correlated to Alcoholism. The “extremely hot spy” problem is essentially unsolved.