@Germlat,
Sometimes we do things that we "need" to do, so that we can move on and not live with it, because it's too late.
Even if he said that, "you are going to retire in a year", after 25 years together, one would think he would understand the need for closure in that regard, if that is what you need.
I feel some circles here. Then why aren't you initiating the sex, that he has to ask for it?
You are also suggesting that your colleague was very supportive and you spoke to her several times a day.. Suggesting that your husband was not supportive, if he is emotional and you've suggested that too, sounds to me more like he thinks your outing him.. Preferring to talk to others and not initiating anything anymore.
He suspects your cheating.
You suspect he's cheating.
See where this is?
You need to sit down and talk.