I believe both things are true: there is a power law distribution, and there will be millions of people making careers like that. Patreon alone has >100k creators, right? And it's not a super popular platform yet. I think the request for content is already there, and is just being dis-intermediated.
Also, I think you are discounting what a lot of "creation" is, as it is a much larger area than is generally considered, IMO.
For example, there seem to be a lot of erotica going on in patreon and elsewhere, where models sell prints and special content (e.g... nipples?).
Or, there is a ton of videogame streaming going on, which
should be considered content creation, and some of the millions of twitch streamers actually make good money.
Many people also sell special content connected to their podcast/streaming whatever, I just ended up yesterday on a financial youtube channel where the author has a paid-only weekly chat with the subscribers.
The only thing which I think won't increase much is writers self-publishing. That seems to already have been a thing for years now.