I think it could work, provided that none of partners is a religious fanatic (or anti-religious fanatic). I'm atheist, and many of my girlfriends have been catholic, and we have had a pretty good relationship (at least in the religious field).
As Harregarre said, they would need to tolerate and respect each other.