The president is pleased with Elon Musk, but the decision comes as the tech mogul increasingly looks like a political liability.