Musk, 53, was accused by The New York Times of ‘intensely’ using ketamine and an array of other substances during Trump’s campaign trail in 2024