By my reckoning the majority of clearances are DOD active or reserve/guard [0]. That alone pushing it to 50+% of the people need to be allowed to have guns even if they only shoot a rifle once during basic and then are supposed to be able to figure it out if shit hits the fan. Now consider 3 letter agencies etc.

I feel very confident saying being qualified to use a gun is essential to the majority of those with an active clearance, and thus highly relevant to the drugs question part of the clearance.

[0] https://news.clearancejobs.com/wp-content/uploads/2022/08/Se...