The man was cheating on his wife. He already wasn’t thinking of his family.
Men are known to think with their penises every now and then. His wife knows that too. It's cheating, but cheating is often repaired.
Allegedly he was assaulted by a spy and wasn't able to deflect that assault. Who knows what techniques they use, wouldn't be surprised if they can sprinkle something in a drink that switches off half the frontal cortex.
I think it's common enough for people to have regrets after the fact. Not all do, but enough that you can't rule it out entirely.