Sex life suffers as prostate problem causes male depression

He is in his 60s and is very depressed. Our sex life, though not very active, has come to a standstill. I feel shut out and unable to comfort him beyond serving meals. What can I do?
A diagnosis of cancer is devastating in anyone’s life. Your husband is adjusting to the diagnosis.