It’s weird, but you are usually scared for nothing. There is no point of being scared of falling down, until you actually fall down.
Moreover, there is something magical, blissful, when you overcome your biggest fear.
It is very true about mountain biking. The sport brings you amazing reward when you are able to land that jump perfectly, go through this rock garden at max speed or go down that technical section smoothly.