Our current standard of service "everything in tech should be free and paid for by ads" is pathological on so many levels.
First, it turns us users from customers into product, and the corporations are free to ignore our grievances or to deny us actual support.
Second, while programs scale well and you can service the whole humanity with a few server rooms, this isn't true about the non-tech part, e.g. moderation, just enforcement of policies etc. These are human-heavy and expensive, and their cost cannot possibly be borne out of ad revenue alone.
Third, by relying on ads for money, the networks have a huge incentive to develop intentionally addictive products. The more time you spend on the network, the more ads you see, ergo the more valuable you are for the business. We ended up with virtual equivalent of the opiate crisis, the algorithms do their darndest best to polarize us and keep us online.
That said, people after 25 years of free services would probably rather run than accept payment, and Musk as the face of this change does not inspire many either.