You're struggling with the same kinds of questions that have plagued writers for centuries, me thinks.

I do think there are more than 500 writers living solely off their writing, however! So the trick is to transform yourself into one of them. It'll probably take several years, though.

I'm all for mindless temping and day jobs that don't require any mental energy at all. Hard to find, though.