Based on the direct reports despising him and wanting to leave, wouldn't you say it's time for him to go? If he's been like this for two years a weekend retreat won't fix things.
Explain to the board your position and go fix your company. He'll thank you for it later when his shares are worth something.