Presently, a provincial government that invokes the clause isn't required to say which particular Charter rights its legislation needs to be exempted from.
The NDP's Bill 50, the Constitutional Questions Amendment Act, aims to change that.
It would automatically trigger a process whereby a Manitoba government wishing to invoke the notwithstanding clause would have to explain its rationale for doing so to an appeals court judge, according to the NDP.
That judge wouldn't have power to stop the legislation, but could provide a legal opinion on its potential for human rights violations. Kinew has characterized that as a democratic safeguard that may help voters decide which party to support.
This was never credible, and was never how it was presented in DS9.
Even in "Inquisition", Sloan had two other guys standing next to him, and an entire starship at his disposal. Starfleet Command covered for him at the end - something that was noted by the DS9 senior staff.
In subsequent episodes, Admiral Ross acknowledged their existence, and Bashir worked out what he believed to be the bare minimum number of operatives required to create the morphogenic virus (73).
Later, we saw them working for the United Earth Starfleet in the ENT era.
The only suggestion that it's just "once crazy guy" comes from Koval, who then helps Sloan fake his death and is revealed to be a S31 asset in the very next scene.
So no, that's not really something Discovery changed. People have had to wilfully ignore the DS9 episodes to buy into that theory.