I think this question is also heavilly dependent upon how old you are. If you have already been married a long time and have had kids and are looking forward to retirement then sticking together for the remaioning years with an SO who has SRS is maybe not such a dealbreaker. But if you are young and have a full life to look forward to, including children, then it would be very very hard to stay married - but staying friends maybe possible.
