Hi Tammy,
OronD gave you an excellent answer, as always. Yes with all those 3 diagnoses, those really are not going to help a man perform sexually. You can be honest and ask your husband to please you sexually aside fro sexual intercourse. You and your husband know them and it's time to be creative. It's a good advice to pleasure yourself. But I think he will enjoy it more if he helped you obtain pleasure with his help.
Cuddling and just being close will also make you closer. Your kindness, compassion and not making sexual demands will relieve his low self-esteem due to his inability to perform sexually.
Encourage him to always take all his medications so he will be on his way to wellness again.
Take care and keep that smile on your face.