The conundrum

This is what it all boils down to:

Focus on the things that pay at the expense of the writing projects you feel so passionate about

OR

Take the plunge and risk investing all your energy into something that might or might not pay off

If you can sort out the practicalities, then I believe Life is too short not to pursue what really matters to you.