The president was concerned about Musk’s drug use, White House officials say, leading to the explosive end of their relationship