If you were never nervous, life would be very boring.

For example, it is good to be nervous before you try a new personal record attempt in a one rep max in powerlifting. For example, being or feeling a little bit nervous before attempting a new PR you have never attempted in sumo deadlift, the nervousness is good, as it increases your adrenaline, focus, and your ability to successfully hack yourself to do it.