I think you good friend is somewhat correct in his analysis. The only problem is it fits anyone who is a WAS.
Self-centered Damgaged No moral compass
So what's new?
The only thing I see from this analysis is that you are thinking, "Wow, she's really a burden, I probably need to dump her." It's making you mad. Its making you feel used.
I liked hearing about your weekend. You were not trying to be anything, you just opened yourself to receiving love and being joyful. You were having fun.
I think you figured out what needs to be done:
1. Work on yourself. 2. Detach. 3. Be cordial and kind. 4. Do what you feel is authentic, not what will seemingly get a result.
In 6-9 months the situation will look like this:
1. You will have gotten back your groove and passion for life. 2. You will be in a financially stable place. 3. Your wife will either have moved towards you, or will be involved in another affair. (I don;t see her in stasis for long) Regradless of what she chooses, you will be the one to make an informed decision from a place of stength.