No, it's not what the supreme court wants it to mean, it's what the supreme court interprets it to mean, and that needs to either coincide with or directly strike down existing supreme court decisions. And it only decides based on cases that's brought to it.
So today's Supreme Court can't simply device today that the Constitution implies a positive right to a stable climate, they'd first need a court case and then need to justify that position based on existing supreme court decisions.
If the Supreme Court decides something completely nonsensical, Congress can override it. If justices continually act in bad faith, they can be impeached and removed. There's a check on the Supreme Court, so the court won't just go rogue and decide to invalidate or create laws as they see fit.