There are a lot of threads about this topic.
My RAH has a very low sex drive. He said it never came back once he got sober.
He has no problems functioning at all - just no drive. There are no pills for drive, Viagra doesn't do anything for drive. It can be very frustrating for sure. WE have tried everything its not that he didn't try. I guess its better than someone having a drive and no function. When we do its great its just not as often as I would like.
How was your sex life when he was drinking?