Wow that sounds complicated.
Having no kids but knowing people with kids, and further to that seeing this happen on this forum as well. Reading instances where this happened.
Yes it changes things. How it changes things is completely individual on the couple, wife and husband. You should be prepared for... anything