Just like any relationship, it CAN work if the two people want to make it work. I grew up in a household that only went to church on Christmas and Easter, and my wife grew up in a Catholic family.
After I proposed to her, I decided that I would support her and go to church with her (mainly because I had an uncle who just refused to go to church with my aunt, and he was a real dick about it. Obviously that marriage ended in divorce). Never once did she insist, or even suggest that I go with her.
I did convert to Catholicism in 1998, and have no issues with it.