https://reason.com/2024/01/10/let-elon-musk-enjoy-drugs/
Hmm... I think that just because he does something, it doesn't mean that drug prohibition policies are suddenly a good thing. Is it worth losing space capabilities over? Very likely not.
Also, it's quite probable that whatever leads to him being, let's say, provocative, is also what contributes to his drug use.