According to ESRB, this game contains: Mild Language, Violence
Parents don't have anything to worry about. There are no sexual situations, no violence, and no questionable language. It's totally safe, although you may need to have a chair handy for shorter players to be recognized by the camera.
EyeToy owners and techno geeks will probably want to pick up the game just for its uniqueness. It's weird and amazing, and will undoubtedly go down as a piece of videogame history.
Extreme gamers should probably stay away. The game isn't actually as exciting as it looks once you get past the exotic control, being a very pale imitation of SSX and other games of its ilk. If you want this game for any reason other than to use the EyeToy, look elsewhere.
Deaf and Hard of Hearing gamers are slightly screwed. The Eye Toy intro movie does not come with subtitles, and neither does the AntiGrav tutorial. Once you get past these hurdles, everything is smooth sailing because there are no significant audio cues necessary to play the game. Still, subbing info is something that should be standard these days. Come on, Sony and Harmonix.