I find this X doomsday talk is pretty isolated to reddit/other minor social media sites. The site itself is doing fine, and maintains a strong investor/startup ecosystem, with a slight fall in usage after the election (which isn't uncommon for Twitter/X). My understanding is that a few advertisers threatened to leave and then returned after a few days/weeks.

It's a private company now so I don't know what their revenue looks like but they certainly don't seem to be low on cash given how much they've invested in AI. You may not use X but it's definitely not "destroyed" lol