While it may be helpful to try to frame your fear of failure in terms of size (small failures, large failures) the fact of the matter is today's large failure will be tomorrow's small failure.

There will always be a big scary potential failure you are working on.

Sometimes seeing that what you were afraid of, is really small in comparison to something else, helps you realize relativity, and be less afraid of the small failures. That helps one be resilient, I think.

But also, there will always be potential for and fear of failure. Right now your fear is nebulous, and we all want you to overcome it, yourself included. And I hope you will. But after that, there will probably be another fear, which you will also have to overcome. I don't think anyone ever truly overcomes their fear of failure. It's just that, as one gains mastery, the potential failures change. Some day you won't be afraid of starting to write - but you will be afraid the critics will tear your book apart. Or you won't make back your advance. Etc. I guess that is what I am going for.