No, it doesn’t take away or give rights to provincial or federal governments. They don’t have charter rights in the first place, only individuals have charter rights.
The notwithstanding clause permits the province to override people’s charter rights. That may be justified sometimes, but it shouldn’t be framed as anything else. It’s removing rights, not granting them.