They were meant for each other, but Trump and Musk were always going to blow up like a SpaceX rocket