No, but youtube would had to crack down on Audiosurf videos (along with other games) much harder or risk being taken down as a whole.
Steam community would lose its shiny screenshot pictures and depending just how serious things get from it there's the potential that the Audiosurf forum could be taken down or avatar images removed.
The problem with the law is that it's too broad with inspecific definitions and whilst it's unlikely to destroy youtube itself, it will cause such massive changes that the site will be unrecognisable in the new form and will cause similar changes to many other sites.
Exactly what gets targeted will depend on specific media companies, but the short version is that it can be abused in a similar manner to the DMCA (the legislation that is often used to take down Audiosurf videos on youtube) but with much broader definitions (if a google search links to a video, it's liable as well, etc).
A lot of the legislation is beyond policing 100%, but since this can take out entire websites considered 'rogue' (with no clear definition of 'rogue') it's clear that it at the very least needs looking at again very closely.
One of the best explanations is in this video:
http://www.youtube.com/watch?v=9h2dF-IsH0I (it's 14 minutes long, but well worth listening through if you want to understand SOPA and PIPA).
Which is from TED (
http://www.ted.com/), one of the leading organisations presenting the free flow of ideas, which this bill would potentially kill.
Another problem with the bill is that many of the case scenarios with it seem like conspiracy theory nonsense. They aren't, this is a bill with really,
really bad legislation in it that could cause permanent damage to the internet on a global level if implemented.