I hope you have success placing your stories in paying markets and Substack works out. I write for a living and do make money, but you can't get away from having to write what the audience wants. Well, not unless you're very lucky or very famous. Hopefully luck will be on your side. :)