But of the people who actually spent time in the military, you will find few opposed. Even in francophone units, you don't find any that want to drop the Royal from the Van Doos' official name. Hell, every regular force infantry regiment either has royal or princess in its name (and likely most reserve combat arms units but I have never counted). However, I’m willing to bet that few of those opposed even know enough about the military to realize that. That fact is that tradition is important in the military.
Moreover, I think you will find most who are already opposed to the military will be among those opposed to this.