There are very few arts or crafts where an important part of creation is destroying part of what you've created. Even sculptors don't have to make the marble before they start chipping it away.
Inspiration is intermittent and fleeting, and writing without it feels unsatisfying or clumsy by comparison. So we chase after it and try to get inspired again, or we give up on the old project and start a new project, as though that were the only way to write well, or to enjoy writing. It's not.
If no one reads your stories about queer girls in space, that's not a judgment on you. And if everyone loves your stories about queer girls in space, that's not a judgment on you. The work is the work.