No amount of sex now will fix his enjoyment regarding the company of women, his affair, more flings and his unfaithfulness through the years. Those are all major deal breakers!

If he wants a friend, tell him to get a dog.

You have money to leave. Therefore, get your own flat. Ditch the bum. Get another friend and / or traveling buddy.