A lot of people want to support those writers in a Patreon-like model, which is the role that Substack plays for readers who want to help writers have an online presence where they are free to honestly write about different subjects.
I suspect Substack writers are hoping to get elevated to the 'paid writer' status that big names like Andrew Sullivan have. That's the only network effect I can think of with their product.