I gave this movie to my cousin when he turned ten years old. I'm pretty sure my aunt was pissed. Now he's 17 and he actually understands it. And he turned out awesome, so I credit that to myself.
By the by, if you're in NYC, go see Rocky Horror Picture Show live. They do it in almost every city, I've seen them in Boston and Seattle, pretty fucking incredible, or at least a good laugh if you're drunk.
NYC Rocky Horror