No sex for a year, when he’s actively asking for it, suggests that there’s not much hope of change. She doesn’t want to have sex with him, he doesn’t want a sexless relationship. Assuming they’re not open to him sleeping with other people, I don’t see a way to compromise here.