> Musk never intended to make a direct profit
Musk didn't intend to buy Twitter. That's incredibly clear from his statements in and out of court in the months leading up to the purchase. (Also, the fact that he had to be dragged into court.)
Musk being Musk, however, once he was forced to, made lemonade from lemons.