According to ESRB, this game contains: Mild Language, Mild Violence, Suggestive Themes
Parents should not be fooled by the cartoonish look of Dragon Warrior VII. The game contains numerous references to alcohol, sex, and violence due to the frank nature of the dialogue and serious nature of the story. Its nothing that rises above a PG-13 level, so I dont think it should be a problem for most younger players, but parents should still be aware. Also, religion is a major aspect of the plot that, while fairly generic, some might find discomforting because of their faith.
Fans of popular RPGs such as Final Fantasy X will probably shriek in horror at the simplicity of the graphics at first, but if they can manage to get into the game they will likely discover that it is a compelling narrative experience in its own unique way.
Fans of the Dragon Warrior will probably like the game since they are already familiar with its style. In addition, fans of Dragon Warrior IV specifically should enjoy the similar tone of DW7's series story and the subtlety of its plot.