A fear of failure can be both a barrier and a source of motivation to push for success. There are only three guarantees in life (birth, death and taxes), all the rest is determined by your genetics and your environment. How you choose to respond to both can set you up for life or for failure.
Yes, failing is tough, but failing is never the end of a story. It often is where the plot becomes compelling and heart-felt. Keep pushing to write the chapters of what can happen next. What do you want the last chapter of your life to read like?