Scared to be pregnant

I want kids so badly, and my husband deserves them! He is going to be the best dad! But I am so terrified of being pregnant, but more terrified of giving birth. I do not handle pain well at all. I'm scared something will happen to me or the baby or my husband during the pregnancy or delivery or after. Is this normal? Was anyone else this way?