For most people, once they recover from their first episode, it doesn’t reoccur. For others, it’s a lifelong battle. But that doesn’t mean that it’s always at crisis. I can have months or years when I’m stable - though I’m never fully well I can cope with most of my life and am, generally, happy. And I’ve got a good life with people I love.
Despite all you’ve said over the past few months, you truly don’t seem to accept that he’s ill and needs your care - your focus is predominantly on the impact on your life. You’re impatient, after only 2 months it’s far too early to know when he’s going to recover and whether he’s going to struggle in the future. Your focus should be on getting him well not on whether you’re going to have sex again.