This case wasn't so much about Roundup and cancer but about states trying to override federal law.
The federal EPA required a certain label. The state of Missouri provided lawsuits over not using a label different from what was required.
The Supreme Court said no, states can't override the federal government like that.
Notice that the case had nothing directly to do with cancer or Roundup.