Deb - I think I disagree with much of the negative posts here.
Sure, it will be hard to trust him - and it is reasonable for you to insist on proof that he has broken this off with her.
But I think what he has said and done this weekend is right in line with what is to be expected.
For instance - when discovered, he tried to deny it. Why? Because he really doesn't want to lose you. You have done a good job of DBing this past year, he now knows what he stands to lose.
Think of it like a drug addict. The R with OW was feeding him some brain chemicals he is low on. He wanted to quit but the addiction to the dopamine and other romantic chemicals was difficult to quit. He's told you he wants more romance with you. My H's insight was that he wanted all that romance, but really the person he wanted it with was ME. So - if you withdraw and punish and he doesn't have a chance to see he can have those romantic feelings with you - he'll feel drawn back to his "drug dealer".
The really good part is your H has admitted to you how bad all of this has been making him feel. Imagine the guilt he must have lived with every day! I agree with you that subconsciously he may have wanted to be caught - I'm sure my H did.
The bad part is he is a weenie about breaking up with her - I suspect he wants two weeks because he's trying to figure out a way to get her to break up with him! Although it usually is not a good idea to dis the oW, you might gently point out to him how manipulative all her "neediness" is - and how if she REALLY cared about HIM, she would have encouraged him to work on his marriage.