Showing up and being present is about 80% of the battle of being a great dad. You can hack the other 30%. At least that was my experience. Smell that baby’s hair when (s)he is new. The pheromones will bond you and engage you in being an awesome dad. You might also want to come up with a womb song and sing it regularly. I chose “You are my sunshine”. It still calms my DD at 9 years old.
It's worth listening to this advice. Having kids is really hard. And rewarding. And leads to hard changes in your life that you might not have taken on otherwise but in the end are often good changes. Forgive yourself and your fears as often as you can.