Practically, this ruling won't have much effect. There's a team of people at Google already dedicated to removing results like these from the index, as they aren't that great for users. Any counterfeit goods site with enough SERP already gets on their radar, and gets removed/demoted, without action from Us courts.
No, practically, this ruling has a lot of effect. It establishes precedent for the courts being able to declare a web address illegal to publish. The judge effectively ordered that the website be scrubbed clean from the internet, and failure to do so could be construed as contempt.
He has declared that it is illegal to "say" those words on the internet. Besides being a gross violation of the First Amendment, letting this ruling stand would open the door for people to leverage this precedent against other "undesirables".
