YANBU to be scared. It's a very scary experience to be in any situation you haven't been in before that involves any type of pain or discomfort.
I didn't give birth vaginally as had some complications but began to get contractions. They weren't pleasant but I can honestly say I was thinking more about the baby and how she was get on inside me than my own pain. I also did some deep breathes and counted, which really helped.
Complications aren't nice either but I assure you they keep you in the loop on what they will do, how they will do it and why they need to do it. I had to have a bunch of needles inserted into me when my BP went sky high. They were so good in explaining to me and my DP and even apologised when blood went on my dressing gown! They explained why they were doing everything and honestly again all I could think of was that baby was OK. I didn't panic, because I knew that wouldn't help but listened to their practical advice. They explained what would happen if it went back down, they also explained what would happen if it didn't, so I wasn't left with any questions at all.
I needed a EMCS in the end or the one that is between planned and emergency, grade B or whatever it is called. I got in within half an hour and had a spinal so was awake and my baby was OK and I was pretty much OK as soon as afterwards, as was also on medication (I had pre eclampsia). My little girl was fine and although a tiny bit small (6.6) she was absolutely fine! I was just so happy when I heard her first cry it would've been worth any amount of pain.
Just think to yourself it may be painful, it may be very uncomfortable and it may not go to plan but if it was so traumatic (in general - as obviously if something bad happens to someone it can lead to long lasting trauma) then mothers wouldn't have other children afterwards. It's not nice at the time, but 24 hours later it seems so worth it and you'd go through it a million times to have that little baby girl/boy snuggled into you.