FTR, out of many so-called lesbian women who engaged in affairs/flings with women I've witnessed firsthand, all but ONE have gone on to marry men (some second time). Several had children with their first or second husbands. That particular one woman occurred after a 25-year marriage with her ex-husband had broken up and was divorced. Shortly after her divorce, she had her first gay relationship. That one ended about 2 years and this woman went on to find her life partner who is a woman. They're still going strong 15 years on.
For me that was 1 out of 12 women IRL. Do the math. Now you can see why I have very strong feelings/views on this. An affair is an affair.
No matter how much lipstick you put on a pig. It is still a pig. (yeah...not too refined analogy)