My wife and I are married for 32 years now. In 2002 we separated and a few years later almost got divorced, but luckily we didn't finish the court proceedings. ( they added something new into the process, we gave up and let it be). Anyway... We are legally separated ever since, but after coming out the closet and starting my transition we have now become best friends. My wife lives at my and my oldest daughters place when she is babysitting the grandkids. We go out shopping together sometimes, and she stayed bedside with me during my surgery in the hospital, and helped me in my recovery as well has gone with me to all my follow up visits.
After I came out to my children (I have 3 daughters and 1 son) my 2 oldest daughters took me out to a local restaurant to have dinner and talked to me. They told me they will support and love me regardless, as long as I am happy. I am not sure how the initial thoughts of my other 2 children (twins) was, but they all support and love me. They congratulated me on my surgery as well. My youngest daughter (part of the twin) calls me "momy2".

Same for my grandchildren, they all see me as their grandparent and are just as happy with me as the "old" me.
I told my children I don't want to take your father away from you so they call me dad or opa (Dutch for grandpa), but in public they refer to me as female with female pronounce.
My mom is also very supportive and happy that I am now living in happiness with my own self. It did take mt mom and wife some tine to get used to it though.
I also understand that I am very lucky in not loosing any of my close family. I do have a few aunts and uncles who aren't to supportive, but who cares. Their faith doesn't understand ->-bleeped-<- and therefore they don't.
I do truly think that because I transitioned later in life, after my youngest (twin) where 21 and not living with me anymore, that this might have a lot to do with it. At present time my youngest (boy and girl twin) are living in my home, and my wife is her part of the week, doesn't have her own room, but sleeps either in my or my daughters room. I work nightshift, so she just takes which ever room is available.

We don't have intimate relationship, but we both aren't interested.
At the end I want to add that my life has changed for the better and my relationship is 100 times better, and happier.