OP from one who’s been there and done it in identical circumstances - end the affair, end your marriage, be alone and then see where it takes you.
Do NOT tell your husband about the affair because your affair partner told you to. He is unlikely to be the person you think he is.
My world imploded when I did exactly that and the hurt and damage I did to my ex husband and children still haunts me.
I learned valuable lessons from this and 6 years later I choose to still be single.
I am fortunate that my exH and I are good friends now after some turbulent years, he completely accepts his part in how bad our marriage had become, how utterly miserable and downtrodden I felt and why I felt trapped and had my, as he put it, “head turned”. He did actually say he just wished it had been with someone worthwhile rather than the absolute narcissistic asshole that it was!
My children were adult and then 16 and 18 and I am only now in the last 12 months actually in a good place with them. They were incredibly angry with me very blinkered as to how unhappy I was as we kept the state of our marriage quiet from them but the fact I had an affair is unforgivable in their eyes.
There is no excuse for an affair if I could turn the clock back I would have found a way to end the marriage and definitely definitely not had an affair.
I am one of those rare people that would never ever ever do it again and actually cannot believe that I did it. To this day, my exH blames the menopause - It was certainly the most out of character thing I’ve ever done in my life!
Whatever the reason for me doing it, I don’t know. I am normally a very family orientated homebody who loves nothing more than taking care of people..
That got very long what I’m trying to say is - Nice people sometimes do shit things and please follow the simple advice I said in my first paragraph.