Cheating bi spouses and straight wives what are the stats of them lasting ?

we were togther 13 years married 7 of them. He finally came out saying he was transsexual and I had been the only women he was attracted to enough to have sex with. all his past relationships were men. honestly I saw that as gay but anyways. he had two mental break downs and the shrink said he had bipolar and disassocitive disorder as well. I stayed being supportive throughout buying him girl clothes ect i'm not les i'm pan sexual i guess is the term. well he was convinced one day i'd leave so he did has knocked up some i'll be nice girl and filing for divorce btw this new hmm girls bi . i'm left heart broken and really don't believe in soul mate love anymore. I had joined support groups online went to meetings too. whois to say what would have happened do all marriages have to fail when one is straight ones transsexual? and does the pain get easier in time?