Did Elon not do well with X.com(PayPal) back then? Did he not fund SpaceX with profits from sale of PayPal? how can anybody imagine he hasn't a clue? One would need to have really serious ignorance to assume that. As you say, he has done so poorly...His interest isn't in Twitter. The focus of his interest is the dream he had for X.com from back in his PayPal days.
He has already said that acquiring Twitter gets him to his goal about three years quicker than would starting from scratch.
Anyone who thinks he wants Twitter simply for the dumpster fire it currently is underestimates the value to Elon of starting the project with a large, diverse, and established user-base to jump start into a greater plan.
Or, maybe because he has done so poorly with SpaceX, Tesla, Boring Co., etc. it is easy to presume he doesn't have a clue and to discount his vision as being just another flash in the pan like these others?
O ye of little faith.
BTW you forgot the /s, although it was obvious to the non-oblivious.