After two wives and 14 moves, I can tell you this: you will move, and it will be outside of Southern Ontario, irrespective of which Regiment you are assigned to. Although regulations currently permit you to report for a posting without your family, I firmly believe that this option will be more tightly controlled in the future. Either your wife agrees to these conditions, or you should look for another profession. It really is that simple.
As to coping, plenty of people in the Forces have spouses who manage to have a fulsome career that reflect the fact that Officers have to move more frequently than NCMs, but it comes with its own set of challenges.
You need to both go into this with your eyes wide open.