Nothing to do with being a nanny state and the employer responsible.
Obviously the pilot has some self destructive personal issues and needs help and rebabilitation.
I don't think the flight deck is the right place for him, but I do think he deserves help and support to get his life on track.
It will be dark days for him right now and what does a drug addict do when they are down and it all gets too hard? Take more drugs.
Not a good place to be in.