your wife already knows what she's doing is wrong and is likely in quite a lot of pain.
have you read any of the books by harley? you'll learn that, yes, one of the things that's most difficult for people in affairs is leaving their children behind, not being involved in events like yours last friday.
now, to answer your question. it's going to take as long as it takes for your wife to have her 'come to jesus,' where she begins to emerge from the fog. it will happen when it happens and not a moment sooner.
i know it's not the answer you were looking for, but it's reality. you began this post wanting to know the patterns.
the patterns apply mostly to behaviors. we kind of joke about the "wayward spouse script" around here, because almost all of us betrayeds hear the same words and see the same behaviors ("i love you, but i'm not in love with you," and "i just need to have some space to think through things" are very common).
but when it comes to timelines, we learn that these things are more general and that you must control them. you cannot be in plan A forever ... emotionally you just won't be able to do it. plus, there comes a point when you reach diminishing returns and have to move to plan B to protect yourself and your family from the pain your wife is dishing out.
have you read about plan A and plan B? if not, you should do so immediately. read about them here:
what are plan A and plan B?.
this is hard work, no question. you can either be proactive or reactive, a participant or a victim. which will you choose?