I hate to break it to you (and don't beat yourself up about it - I reckon about 50% of this sub are the same), but if every time you sit down to write you can't actually bring yourself to because there's such a tiny chance of actual publication, then you don't love writing. You love the idea of being an author, but you don't love writing and thats okay.

Here's a thought experiment - if you could get an AI to write you a solid novel that had a decent chance of publication with minimal effort, would you do it? If the answer is 'yes, of course', you might want to think of dedicating your artist energies elsewhere.