It's not about him making some mistakes. If he is contrite and gets the help he and his family need him to get then he will find his way out of the mess. Whether his marriage survives is up to how he responds and how much patience his wife has. That's separate from what he's done professionally, which have different consequences. If you don't fire him you are basically telling him he's untouchable.