If he will do anything to fix it, then you need to make him walk the talk. Counseling would be a right direction to try. If he refuses to go. Then this become your problem, in that your willing to put up with this type of one sided
relationship. It is then your move. Pack your bags, whatever you feel will make him preform. Stand up for your rights, and demand to be sweep off your feet. At least ever month.
I assuming he has all working parts and can preform. Is this an age issue maybe.
If he don't want sex, maybe he would be OK with you dating somone else.
for your sex needs.That might keep you happy and he could gives himself a hand job thinking about the porn he likes. Good Luck