It's a big leap from a strong connection to a best friend and EA-OW. How did you make that leap?
This is simple but difficult. You've read the book, 2nd and LTH gave you good advice. Now it's up to you.
Become the man you want to be, the man you now say you should have been. That doesn't include doing everything for you W but it does include working together for the household to run smoothly.
You're not ignoring her, you're doing what she asked and doing what you were doing before. What's changed is you now want something you can't have. I think this gives you insight into how your W was feeling for a long time.
Keep quiet and work on you. Anytime you want to say something to wife, ask yourself: Is this about my needs of her needs?
(It's helpful to have a sig line with the important facts like ages, years married, children, previous marriages.)
Me 57/H 58 M36 S 2.5yrs R 12/13
Let me give up the need to know why things happen as they do. I will never know and constant wondering is constant suffering. Caroline Myss