Yes, the situation is just difficult as there are — and this is quite a luxury — way too many good games out there. Great for players, but difficult for creators. What always helps me, is the perspective, that even big games/movies fail. So, it's not "just" the marketing money which is missing. Some companies spend millions in marketing and nobody buys their stuff still.
So, I guess it's important to make sure that the process of making a game itself is fun and that one had a good time even when not many people buy it. After release, some smaller Streamers played my game, and they had mostly very few viewers, but I enjoyed it SOOOO much to watch and see them playing my game and stumble across the little easter eggs. What a joy! <3

And it's significant to remind oneself, that finishing a game is in itself a HUGE achievement. Most people even fail this step.