It made me cry when I played it, but in that good sort of "I feel connected to these characters" kind of way, not a "this is terrifying" way. So I guess it depends on how mature you think your kid is. It isn't bad for kids, and it definitely isn't scarring the kid, but it gets pretty intense and emotional.
Of course, this opinion is coming from a guy with no children who hasn't been eight years old since 1999.