You asked him to leave and he left. It sounds to me like the ball's in your court. I don't see how you can expect him to be psychic and know what you want him to do.

That was pretty selfish of him to tell you about the affair. It's certainly not anything that would have hurt you if you never knew about it. He did it to clear his own conscience with no regard for you. Unfortunately the cat's out of the bag now and you're the one who is stuck having to deal with it. It's perfectly reasonable for him to be waiting for you to decide how to proceed from here. When you ask someone to move out, it usually doesn't mean "and call me tomorrow."