Is this a final judgement? Is it over now?
That is true.
> The only way things could change now is if Congress/President passed a new law
That isn't true at all; the Supreme Court is free to change the law by itself. Someone could sue over the same question and get a different result overruling this one.
https://en.wikipedia.org/wiki/List_of_overruled_United_State...