My sympathies OP. My wife is the same.
Despite my MANY attempts on all levels of our relationship to reconnect, my wife has rejected and ceased ALL intimacy and sex. She too moved into the spare room without discussion.
IMHO the only thing that really defines a married partner as opposed to anyone else (unless pre-agreed) is the intimacies, physical contact and sex that you share. Without that, you are nothing more than friends who ‘get along’, or housemates with shared responsibilities for chores, obligations to pay bills and co-parents.
But kids complicate things. I am very unhappy and do not want a life like this. However, I also believe kids need both parents and as me and my wife are perfectly amicable in all other regards, I don’t want to hurt my kids in that way. Like many, money is also a major factor, as there simply isn’t enough of it to split on all but desperation terms.
Therefore, I stay, at least until the kids are past 18 and the mortgage is paid. After that, we’ll see.
I know some see that as a sacrifice too far and believe that it some how sets a bad example to your kids, but in our case, I think they still see us as connected, even if below the surface we are not.
And before anyone here suggests otherwise, I have pulled my weight, helped with childcare, not just been a Disneyland dad, complemented her, been nice, tried every approach from not mentioning sex for months, through to trying to spice things up, and all the while offering clear opportunities to talk to me and explain her needs or tell me if it’s me who’s done / doing something wrong. In other words, she’s had AMPLE opportunity to say she’s not interested in me because I haven’t done the dishes, folded the washing right, coughed at the wrong time or worn the wrong coloured pants…
As another poster has said, I think she like the paycheque and security, but saw intimacy and sex as a build-up to making babies and now doesn’t see the point. She seems content to live like this and ignore my feelings, because a) that’s the way SHE wants it, and b) probably thinks that the other things she does / her share of the chores makes up for it.
In direct answer to your question, it’s not over so long as you’re still there – anything might happen – but I suggest you at least mentally plan for a future without her in your life.
More than anything else though, a refusal to TALK automatically leaves that person 100% in the wrong. Period.