Terrified !!!!! Of childbirth

Okay so I just watched one born every minute and wish I hadn't although I did cry and get emotional it was truly beautiful to see how magical child birth is but WTF I'm literally so scared of the pain the women were screaming and cursing and then along came the epidural and there was silence ... what is this magical injection I've heard so many horror stories about ... I think I'm gonna need it but heard so many bad things I'm terrified of that too .... can anyone who has experienced this she's any light ???