Both of my wife's pregancies brought us much closer together. My wife is a very self-sufficient person, so I didn't obsess on protecting her while in a "delicate condition" but I did try to be as helpful as she needed to be. During her second pregnancy we had some of the best sex of our lives, because she was sooo horny.
Both of our sons were born at home with midwives, and preparing for that really brought us together.