The Republican president is famously prickly about being outshone by anyone in his entourage, and there has been widespread speculation that Musk’s high profile could lead to his downfall