80-20 rule applies. Only a few will become truly well known, and the others will scratch and scrape for crumbs.
Back in the 2000s, 'blogs' were all the rage. It was where 'real journalism' happened, away from the red tape and PC-ness of newsrooms. Sound familiar? 15 years later, somebody like Andrew Sullivan or Breibart are the only 'bloggers' people even remember.
What's new is that rockstar opinion writers with enough name recognition are able to generate clickbait targeted for their specific followers and make a living in doing so, rather than relying on the opinion sections of major publications. So now i guess the established troll farms like the NYT or WSJ editorial pages are the clickbait minor leagues while Substack is the majors.
This doesn't seem to be any better, really.