How do you handle finding out something about your spouse or mate that you find despicable or disgusting? What do you do now?

Depends on what they did.
I was with a liar years ago. But stayed with him for years. Had enough of his lying, drinking and dealing drugs then fled with my daughter. Never saw him again. He died years later from being homeless.