OP - a few books that might help you right now.
The Way of the Superior Man, by David Deida. Google search it, and you can find PDFs of it online for free. Start with 29: "Choose a Woman Who Chooses You". Then read everything. It's a short book. You'll want to keep coming back to it.
And then:
Just Listen, by Mark Goulston. This book helped save my marriage. When you're ready to have the tough conversations with your wife, this book will help you lead them.
You're not a broken man.
You're a man who remains committed to a woman who checked out your marriage years ago. Yes, marriage is about sex. There are some people who choose to work a job for free, because they want to do something meaningful with their time, belong to something bigger themselves, etc. and don't really care about bringing home a wage. But for most of us, we'd stop working a job if it stopped paying. And for most normal, emotionally healthy people, sex is a requisite of marriage. That's why they call it "making love".
Maybe you can save your marriage. None of us here are in a position to assess that. But I know that you would never be at peace with yourself unless you gave it everything you can. So, read these two books. Be prepared to change everything in your life, including your woman. Be prepared to acknowledge and accept anything she might tell you, even if it's painful.
If she doesn't want you, there are literally THOUSANDS of other eligable women you would find attractive, when you're ready to love again. After being in a sexless - loveless - marriage for so long, you may feel that nobody would ever want you. But you're wrong. You might need to shape up, pick yourself up again, refresh your style, etc. But there are so many women around your age, a bit younger, a bit older, who'd give their right arm to find and keep a good man.
Don't waste your life staying with someone who doesn't want you. But don't throw away years of marriage based on some advice from the internet. Read those two books. Walk the hard road ahead. And whatever happens, you'll be okay - whether YOU decide to give your marriage more time or find someone else.