A Wall Street Journal report alleges that Musk has used illegal drugs for years, and it is concerning executives at SpaceX and Tesla.