If he has libido killing meds then he has a medical reason for not participating in sex. It happens, and couples adapt, couples accept these bumps in the road.
Or they separate/divorce, kill one another - whatever....
Last year I ended a 14 year relationship.
For the last 12 years of that relationship we didn't have sex. He had gotten a positive test score on his HIV test, he didn't want to infect me - blah blah blah. Sex went the way of the do-do bird and I grinned and bore it like a man because I was in a monogamous relationship and faithfulness was far, far more important to me than getting off.
I literally haven't had sex since the last century....
That isn't to say I haven't orgasm in the past 13 years... I have hands.... Something which I assume you have at least one of, or did you type your question with your nose?
Yeah I know, there is intimacy with a person one doesn't get with the hand(s)... however there is no reason why you and your partner cannot still hug/cuddle/snuggle while watching TV or whatever it is you two do together.
If he is unwilling to do that, then there is something else wrong in your relationship, and perhaps couples therapy is needed to address THAT (the low libido is a medical condition, no amount of therapy will fix it).