Boomer norms aside, is smoking weed really that bad compared to say, a CEO who likes to drink socially? It's not like he was caught hotboxing in his model 3 before his workday started.
Disclaimer I drink but don't smoke, so if anything I'm biased against my point.
There's also the angle that weed is federally illegal, so smoking it demonstrates an attitude that compliance with rules is optional and subject to personal judgement. Someone with that attitude is probably more likely to choose to not comply with security procedures or secrecy commitments.
To have a mistress is fine. To get caught in a public spectacle is bad judgement.
Still it's a blatant example of how illogical us humans are.
[0] https://www.pbs.org/wgbh/pages/frontline/shows/dope/etc/cron...
EDIT: Regarding the maybe, replace that with "NIL". In my opinion a lot of the security concerns are coming from blackmail risks. In turn a lot of blackmail risk comes from the clearance process itself, so a home made issue Just where do you draw the line? Tricky question.