The statistics show most affairs will run its course and will (usually) fizzle out within 6-24 months, no matter how unique the affair partners think their relationship is.
Why do affairs fizzle out?
Part of what makes an affair's relationship work is the secrecy and excitement of keeping it a secret. Once the betrayed spouse finds out, the affair loses a lot of its appeal. The new partner doesn't seem as enticing when it isn't a secret anymore. So, affairs usually fizzle out after the affair find the light of day.
How do affairs usually end?
Affairs usually end in one of three ways: divorce and remarriage, divorce and relationship loss, or the recommitment to the relationship that was betrayed.