Even if Twitter is a complete financial loss (and I think he will lose a lot of it), Elon will still be a billionaire. His personal life will feel zero of that impact.
He doesn't know what he's doing unless his main goal was always just to distract a bunch of people away from something bigger. On the concrete end I think he'll eat shit like Verizon/Oath/Yahoo did when they lost $0.8 Billion dollars on from their initial purchase price reselling Tumblr after ~6 years of ownership after running its userbase into the ground and scaring away all of its most competent original staff.
His twitter profile currently says "Chief Twit". Teenage boy level humor but the joke is on the joker.