Nonsense. Plenty of CEOs drink excessively, pay for sex and do cocaine. They don't do it on video with Joe Rogan, though. That shows such a complete lack of discretion.
No it's people who are invested in Tesla being concerned about Musk's mental health and his ability to run his business. In particular because that wasn't his only scandal.
And it's got nothing to do with the US either. Do you see many German, Swiss or Japanese Ceos smoking pot and getting drunk on podcasts?