I think that this could have huge ramifications on a lot of different levels depending on what Anti-Trust exemptions the league DOES still have. Here is where I see issues..
No. Or at least not for a good while.
THE NFL DID NOT LOSE THEIR CASE against American Needle.
A lower court ruled against American Needle. The Supreme Court just overturned that ruling. But they did NOT decide the case. Instead, they disallowed certain aspects of the original ruling and sent the case back to the original court to be decided based on its merits.
But that does not mean that without antitrust exemption the NFL can not still do all the things it now does, including exclusive contracts. Again, no court has yet said the NFL can't give out exclusive contracts. They've just said they need to conform to antitrust law if they do so.
If the NFL had won, then there would have been big ramifications, including on the labor front. That didn't happen. Now, the NFL will likely continue what it was doing, but being careful to do so in a way that will still pass court challenges. So there will be an effect but nowhere near what some people are saying in the near future. The American Needle case was filed in 2004, it's not going to get wrapped up tomorrow.
Also... many of the points such as "games will no longer be exclusive" ignore facts such as, even if other games makers could license team logs, they would still need to license the word "NFL" and the NFL logos, which clearly aren't covered by the ruling.