I hope this does not sound mean or harsh, BUT I say let him go and go to counseling for yourself. I know you have to earn your way out of a marriage by doing whatever it takes to save it, but he said he does not want to be married. You also had to beg him to go to counseling, so he may not have anymore loving feelings toward you. Think about it. If he TRULY loved you, would he have strung you along all these years knowing he did not want to be married for the ENTIRE marriage? And that is fine, thinking rationally, you couldn't even find one thing about him that you loved so much to add to your list.
You know what is worse than being married for 8 years and then getting divorced? Answer: Being married for 8 years and 1 day to someone who does not love you anymore.
Keep your head up and be selfish for once and think of what is best for you.

And remember:
TIME HEALS ALL WOUNDS! That "knot in your stomach" will go away. Especially with counseling and self TLC.