Haha. The Modern Warfare games are definitely about as far fetched as it gets — surprising considering that the earlier CoD games were relatively realistic — but then it's not really any worse than various silly action movies and TV shows. It makes for good entertainment and that's about all you can expect.
Their effect on children shouldn't really be a factor as Modern Warfare 2 is rated 18. Blame the parents.