Your body stops being your own. Even if you have a perfect pregnancy, you become immobile, hot, and sore. I love being pregnant, but it isn't fun. My kink comes from watching someone else enjoy being pregnant but I haven't liked it so far.
How long does it take before you feel like that? Like at week 32 when you're undeniably huge, or even just when you start to show?
I can't speak for women (Im male), but I read about pregnancy from women who experienced it online. They love it/hate it/go along with it/dealt with it/ups and downs/all arounds. To have a developing baby inside your womb is weird, but can be cool…I say cool weird, and this is from a few individual women who enjoyed it one way and can't stand it another (discomforts, symptoms and complications). And yes, many (not all though) said they were more horny than before pregnancy.