Hmm, I had pain on and off for a few months, and also thought my scar looked horrible - and then at some point it just got completely better, so that by 1 year on, I honestly couldn't have told you when the pain stopped, but it was long gone. And the scar disappeared to no-big-deal proportions. With luck, yours will so the same - but it probably will take several weeks and months, and you might be quite worried and depressed about it at the time. If pain gets bad, or wound starts oozing (happened to me a couple of weeks in, I think), go to GP, they will probably prioritize you and sort you out quickly. If not, make a fuss. Women who've just had surgery and have tiny babies to look after need to be looked after themselves.
Also - I found things like carrying the baby and pushing a buggy really quite tough for first 6 weeks, and I couldn't use a baby bjorn or similar sling for a month or two. And my baby always seemed to have his legs dangling down to kick my scar, it was agony! I couldn't wear non-maternity jeans for about 4 months, or normal knickers, because it felt really tender and the waistbands cut into it, ouch! But then it suddenly all got better.
Don't worry, it's very early days for you. If you'd had an op like this without childbirth, you'd expect a few weeks recovery, wouldn't you? Try to be strict about not doing heavy stuff at first, just mooch around at home and start to do outside/normal stuff gently and get other people to help as much as you can - don't go on long walks or push buggy up hill without expecting some serious discomfort at this stage! Your body has to recover, but you will probably be absolutely fine. Two years on, it's all a distant memory. Hope you start to feel better soon and congratulations on your baby.