I agree, as parents we worry a LOT about the little things that a kid might not even remember. That's part of the torture of being a parent, you guilt yourself about entirely too much stuff. It's unlikely a caring parent is going to doom their kid by a little bad judgment, but still, you pressure yourself because you care.
Society's judging eyes do make it worse these days as everyone wants to tell you how to be a parent to your own kid.. that they don't know anything about.
The only people that can tell what a kid should or shouldn't be exposed to are the kid's own parents, and even then each of your kids have different capabilities. Lord knows mine are different. LOL
All you can do is your best. We have a lot of tools now, like ratings locks on tv's, internet filtering etc, but as always, there's that kid whose house has lax rules that all the kids want to hang out at to watch horror movies. LOL
I give my kids some leeway, within reason, when I find out about stuff like that. Getting away with the little harmless rebellions is also part of the fun of being a kid. As long as it isn't too much.