As Mr. Musk entered President Trump’s orbit, his private life grew increasingly tumultuous and his drug use was more intense than previously known.