The truth is that most of us fear failure in something at some time or another. It is often helpful to keep things in perspective, e.g. understanding what won't happen if you fail, etc. and then think about the positive things that could happen if you succeed. Remember, also, that courage isn't the absence of fear; it's a determination to act in the face of it.
https://hbr.org/2018/12/how-to-overcome-your-fear-of-failure