A situation I can relate to. I gave up (paid) work after my youngest turned 2 unitl then I juggled 90% of the childcare (when I wasn't at work) with a full time career. DH is a solicitor and I was a dentist. Because of the nature of my job and that of his (ie I worked to appointments whereas he could fly to the other side of the world at a moments notice, not be home until 3am etc) the responsibilty of childcare was down to me. Something had to give, and by mutual decision I gave up my job and became a SAHM.
I found the hardest thing was loosing my finanical independence. Not bringing in an income and therefore having to get over the fact I felt anytime I spent it was spending dh's money, so felt guilty was the most difficult thing.
DH fully respects and supports me as a SAHM and being able to get all the mundane stuff out of the way during the week has meant the weekends are lovely as family time.
I agree with others who have said you need to make the effort to maintain your identiy as you, not just a mother/wife/house wife.
I have ensured I am still busy and stimulated - I am chair of the PTA, learning to play the piano, staring up my own cake decorating business, read, take a keen interest in current affairs. I agree dh doesn't want to come home and discuss coffe mornings, toddler groups, weaning etc and nor do I tbh.
Also the other area that suffers is keeping yourself on a par with friends who continue to work. Our social circle is full of proffessionals and I am currently the only SAHM. Therefore I need to be informed of things going on in the world so I don't bore them to death, or sit in silence at social gatherings.
It is a huge leap from my old life, but I think as long as both of you are supportive of each others roles and you strive to maintian your itentiy, it can work.