Good advice for your writing career can come from unexpected sources.
Two important places for you to check out- though the people involved have written books, they are less known as "writers" than other things- Seth Godin is a business/marketing guru, and Scott Adams is a well-known cartoonist who draws Dilbert.
Seth has so much terrific advice for the modern "authorpreneur." One of his recent blogs is crucial for your understanding of the modern book market.
He says that your biggest problem isn't 'awareness' (or the buzzword 'discoverability' for writers). It's not that you should shout all over social media about your work so that more people will hear about you, it's about creating such a value proposition that people tell other people about you. He persuades you that it's better to produce something remarkable.
On social media, I skip over all self-promotion- they're shouting in hopes that someone, anyone, will follow the link. But when someone else recommends a work, and tells me why, I'm much more inclined to check it out. So when you write something so good that other people push it, that's the key.
The second thing to check out (see there, I found great value and am passing it along) is the book by Scott Adams, How to Fail at Almost Everything and Still Win Big.
He hits on a number of points to absorb, the first that perseverance matters over temporary setbacks. He got lucky by constantly working hard to put himself in positions to get lucky. Like Edison with the light bulb, he "failed" at many things, which all taught him something, and which he accepted as moving him closer to his plan for success.
The takeaway for me is that he shows how to decide what you truly want and set up a system for long-term success, not just set goals. A goal may be met, or not, and then you've either failed- or have to start over with new goals. It's paradoxical for us as humans- shortly after we meet a goal, we're dissatisfied, and seek something else. We work so hard, and the satisfaction is temporary.
Creating a system means you're always in progress. It's strategic thinking rather than tactical, and is a better indicator of eventual success.
He has many other life lessons here, also stressing the importance of knowledge and learning.
If you take a bit of time and study the book and the post, you will have a better understanding of what you need to do to continue a writing career for the long term.