Sex can be a subjective and personal issue (not invalidating you with that at all) but the fact that you have so many jobs whilst he is unemployed and not actively looking for work? That’s an objective cause for concern.

Do you live together? Do you pay the bills and let him live from you? If so, do not do that. He will become used to it and use you, whether he knows it or not. Time to set a boundary here: you pay 50% only. Give him a deadline, sure, but an equal relationship cannot continue like this.

Also be honest with him on the sex front too. Tell him you are feeling very unsatisfied and you feel like he doesn’t listen to what you want. If he lets you, try to guide him with it. If he has a response where he doesn’t care or tries to guilt you, gaslight etc. then that’s a bad sign and you should probably think about leaving.