Well, I wouldn't say Musk failed miserably. We don't know how much bitcoin he bought before Tesla's investments became public. With his twitter posts, he obviously tried to drive bitcoin's price to even higher levels.
When bitcoin was on ATH, he could have comfortably dumped large amounts and now is filling his bags again with cheap coins.