I'm so sorry this has happened to you. I have been there myself, twice, and I know that the task of rebuilding things seems so daunting. i would advise taking baby steps and trying not to expect that things will suddenly feel normal again. It is a slow process but it can be done.
I don't think that a relationship can ever get back to being exactly the same again after an affair. But you can recover something that different but still worth having, and even, possibly, better in some ways (more equal? more realistic?)
My h still works with his OW, which has been a torment to me. I wish now that I had insisted on them working separately, or at least that I had immediately set explicit boundaries for their behaviour (ie completely, utterly professional - no flirting, no meeting for lunches, drinks etc). I thought it would be common sense for them to be completely cold towards each other in the aftermath, but in fact I discovered that they were still reminiscing and flirting by email 4 years on. Cue more pain and opening of old wounds.
So I would strongly advise that you try to get them to work as far away from eachother as possible and to set up very clear boundaries which you are prepared to enforce.
I also agree that you should not let him be too self pitying for long. My h was hurt in an accident almost immediately after his first affair, and i had to go straight into caring, sympathetic mode. And I actually think that this set us back badly. I needed him to be regretful and sad, but also responsible and strong. I needed to be the one receiving comfort and care - not giving it. And this time I have told him absolutely clearly that I need him to be strong and positive. Maybe this is something you could tell your h too if if would help?
I think that something has to change and he has to focus on proving himself to you - on winning you back.
And I wouldn't advise doing what I did first time round - thinking that witnessing my pain and suffering would be enough to put him off doing it again. After 'getting over it' all my myself, I never mentioned it; never spoke about it - just pushed it down deep inside.
Now, doing it again second time round, I want to be something not hidden away and unspeakable, but something that we can talk about together, that we deal with together, openly.
I definitely agree with suspicious that it is better to set a time limit on the thinking and going over things in your mind. I thought I might literally be going mad, as things raced round in my head, and it was getting me nowhere. Counselling was hugely helpful in getting my thoughts sorted out.
As regards regaining intimacy, I am not sure what to advise, because I don't think I am there yet. My body is there and enjoys the physical closeness, but my mind and loving emotions are not properly back there yet. Sometimes i even cross my fingers.
My strategy is that by keeping the physical side going, and not making it into another hurdle to get over, eventually, as my trust builds back up again, the love will come back too.
I do think I am getting there (slowly) but it is hard to keep to intrusive thoughts out. And I can't seem to say 'I love you' any more, which makes me terribly sad.
I will look forward to hearing what other, wiser MNers have to say...