HeartNSoul, I'm sorry you're going through such a heartbreaking coming from the collapse of his big lie.
It's hard to say what's going on with him now. He may be sober and seeing the world as it is without the haze of alcohol. That takes some adjusting to. These columns are full of posters who don't like their newly sober partners. He was charming, but he was being helped along by his favourite drug.
I think you're right to give him space, difficult as it is for you. Let him work through his issues undisturbed, and he may come back when he's calmer. If he doesn't manage to stay sober, at least you know the truth now.