I'm sorry your upset, but, yes it's probably the hormones that have trigger you. He probably meant it to be sympathetic think "oh you poor thing, your body really isn't enjoying pregnancy, is it, at least it only lasts 9 months" etc.
I also was terrible at being pregnant and am very apprehensive about the prospect of ever doing it again. PGP, ICP, premature rupture of membranes and early labour, and morning sickness that has caused me severe dental problems.
However, my midwife friend once told me people tend to get 1/3 bad: terrible pregnancy, birth or breastfeeding experience. And she was mostly right - my daughter popped out in a 1.5h straightforward virginal birth. Breastfeeding was pretty tough, too though, as I never made enough milk, but my baby latched and fed nicely from the start.
So I can say for certain that not being cut out for pregnancy has absolutely no bearing on what happens once you're in labour. Hang on in there, and give your husband a good hug! Do talk to him about your insecurities about becoming a parent though- we all have them, and the two of you will get through them most easily working as a team.