Tesla CEO had even expressed his willingness to serve after Trump hinted that he would consider Elon Musk for a cabinet role or advisory post if he wins