Like other reviews, CommonSenseMedia doesn't tell you the whole story. Now, for the blood/gore/violence, when the game is first put in, like other CoD titles, you can chose to enable or disable graphic content, so simply be there when he/she unboxes it and puts it in the console. This eliminates any "red liquid" coming from killed players. However, red stuff still is part of the maps and still comes up on your scree when you are injured, but it is not nearly as graphic as before.
Now to the concerns. There is one word of language in Multiplayer (probably what you kid wants it for). Whe playing as the team "Mercs" a man will say in your ear at the start rarely, "keep your head up and a** down, it's go time". Also there is open throwing around of bad words such as f***, s***, d**n, d**k, and even in some cases, c***. However, there are parental controls on the Xbox itself's settings to disable open chat to random players. ( I don't know about PS3, but I assume so). Campain is littered with bad words, but so is Middle School. If you think you child is mature enough to handle this, then by all means, it is a fun game that I enjoy playing myself.
Thanks for Reading