It has never worked and will never work. What has been proven to work is syndication, ie putting a giant amount of content behind a single paywall. Like Spotify, Netflix, Cable TV, other streamers do. Text publishers could easily do that if they wanted to. But it needs to be extremely broad, and not decided by ideological leanings or snobbery and such.
I can see Substack attempting this, and being opt-in for publishers. But I can't imagine this being good for independent publishers.