Should I stay or Go?

Should I stay or Go?

I'm a married Man (41). Been with my wife since we were both 17 and up until last year its the only relationship either of us have known.

We have 2 kids and on paper everything is rosy (house, car, happy kids etc etc) but me and my wife are not 'in love' anymore. We have a great / solid family unit but no love and haven't shared any form of intimacy for many years. She is a wonderful women though and the best mother of my children i could possibly want. We never argue - but this is because we avoid any kind of serious issues / conflict and just drift through life not wanting to rock the boat.
I thought this might be normal and just what happens in LT relationships? But last year i met someone, which has turned into an affair (mainly messaging but also now a number of physical meet ups) and we are both now in love. She makes me feel alive, she's young, fun, gorgeous and very funny and we get on so well. This girl is single and desperately wants me to end my marriage so we can be together. If i don't she will move on as 'life is too short to keep waiting' and i don't blame her for that.

I think i have 3 options and would be grateful if anyone who has any experience of this (or not) would give me some advice because i'm pretty desperate now and not sure what to do. So, do i:

A) End the affair, confess to my wife and 100% commit to my marriage and do the best thing for my wife and children. But live with the regret that i may have missed out on finding true love and happyness.

B) Separate from my wife to be with the girl i love - which excites me so much but also in the knowledge that i will probably lose a lot of my friends (in my wife's circle anyway), upset my children, financial aspect of divorce, and also have the worry that if the new relationship doesn't work out (i know the spark could go once it becomes 'real') i could be left in a pretty sad state on my own and with a lot of regret.

C) Suggest a trial separation and just be single and explore the single life that i've never had. This runs the risk of losing both my wife and my new love but also endless 'new' potential.

What does complicate matters is that my 'affair' is no longer a secret (the girl i'm having the affair with is now friends with a lot of my friends and even my wife's friends) and a number of people now know and it will probably get back to my wife at some point.

Its all a bit of a mess and i need to act soon but don't know what to do. I'm trying to think clearly but instead i find my self turning to drink / substance abuse as a way of blocking the reality of it.
Thank you for reading if you got this far. Help?!