I would remind them to consider the number of lesbian women in the world that get off without a penis being involved. If we are talking about pleasing your partner, there are so many effective sex toys that will assist and can be fun for both partners.
If you are talking about not getting pleasure yourself, you can still have sexual touching, kissing, and playing without an erection and it can still be very pleasurable.
You could also use the situation as fuel for fantasizing about a cuckold relationship and possibly getting your partner to agree to explore sex with another man.
I have had a recent health issue where I struggled with getting and maintaining an erection and my wife helped me through it with oral sex and playing with toys. She is able to cum and squirt multiple times with my mouth, fingers, and toys in and around her pussy and especially her clit. It was still a lot of fun giving her pleasure even when my very average cock wasn’t able to participate.