Fear of failure is a common trauma response and a manifestation of the situations you faced growing up, it is also a prominent symptom through which several neurodivergent conditions (like ADHD, OCD etc) are expressed. No shame in getting checked and/or finding coping mechanisms in the meanwhile (think gamifying, challenging your ego, spite, shame etc. although not healthy)
But reiterating the common cliche, focus only on the inputs, the consequences of a bad output are never as bad as they are in your head, but not attempting definitely is.
As a teen and a relatively young adult, I used to Chide at the mention of personal growth thinking it is an excuse against spending time acquiring knowledge or hiding from honig skills, but then once you grok what it actually means and what it changes for you, you won't leave the path. I mention this because, the returns are non-linear/not apparent for the time you spend, but stick to it and trust the process