A "norm" can refer be either descriptive (average) or prescriptive (standard), but "normative" specifically is an adjective which refers to things establishing or relating prescriptive norms (this subtle distinction is often not made in short dictionary definitions but is readily observable in use.)

Normative is just the adjective form of "related to norm" - can still be perfectly descriptive in use. The difference you allude do is more about the practical enforcement of a norm (or lack thereof), than the kind of the part of speech use to refer to it.

I 100% understand and empathize, doesn't mean I agree.