That's a lot of nice positives there, roist! My guess is this marriage is yours to re-make... or end. Your wife isn't going anywhere. I'd suggest you quit anticipating a bomb and move forward with this in mind. Your wife does not sound completely checked out.
Have you read Michele's book, Sex Starved Marriage? If not, you should. I can't over emphasize how big of a difference even small progress in this area will keep you going! Bust On!
M: A really long time. Crisis: 5 years. She's still worth it.
Life is never made unbearable by circumstances, but only by lack of meaning and purpose. -Viktor Frankl