Lack of sex drive/libido in husband. Advice?

Hi all this is my first time posting on here other than helping people in the comments. Please forgive this essay I'm about to write! 😅

Almost as long as I've known him (going on 8 years), my husband uas had a lower sex drive than I thought was average. I've only had one sexual partner before him, and we were high schoolers so my frame of reference on "normal" sex drive isn't exactly accurate. His libido has been declining over the years, and we have tried many things to aid it. We have tried new things in the bedroom pushing past boundaries and finding new things I never would have thought possible for myself, viagra, limiting his exposure to porn/masturbating when he thought it may be a problem, trying to initiate intimacy more often and letting things go wherever, watching porn together, going to sex shops for new ideas/whatever sounds fun... Basically everything short of therapy. Other factors definitely play a role in this and I dont know what does what. We are very open with each other, and are both at a loss. He feels guilty for not having the ability "to please me" as he puts it, and I feel guilty for feeling so intensely horny and attracted to him.

We both suffer from depression and he struggles with alcohol abuse, and has been able to limit it. He drinks 3-4 drinks on weekends only. We are trying to limit it further, slowly so that he doesn't snap back to binging. Doing some research I just found that substance abuse can lead to a lot of the same issues it seems he is facing. Is there anyway I can help him other than trying to support him like I am? If the erectile dysfunction/ lack of libido is alcohol caused, will that go away if he stops drinking all together?

Seeing a sex therapist is out of our budget for the moment, but it is something we are both open and willing for as it puts a strain on our otherwise very healthy loving relationship.

Any and all advice is much appreciated!