Considering the company is now, according to the CEO, close to break-even and slowly beginning to bring back advertisers and anticipating profitability in Q1 '24, I think they're going to be around for a while longer.
Beyond that element, I believe that Musk wants control of the company at least until/through the next presidential election, so X/Twitter probably isn't going anywhere in the near future.
As far as people not using it, I think those that were going to leave have left already, so I don't anticipate a huge exodus.