I have watched this movie probably around 5-7 times, and it never gets old. The scenes and acting keep you glued to your seat, wanting to see more. It's filled with a ton of "How are they gonna get outta that one?!" moments (like when the crew is running into a carbon dioxide problem) and other scenes (like when they have to power the entire spacecraft with just the power used to run a coffee pot) that keep you wondering how they will solve the problems to bring the crew home. Although there are a couple sexual scenes (one showing a man and a woman in a shower together, nothing is seen though, and another part in the opening scenes when a man talking to a woman shows what happens when a spacecraft docks with the LEM, representing her as the glass and him as the beer bottle head entering the glass) its not that bad. And "the clap" part that they bring up in the "Sex" part of the Common Sense review I didn't even catch when I first watched the movie, and when I did catch it later on, I still didn't even know what "the clap" was. As for the drinking and drugs part, it's barely noticeable. There is a fair amount of smoking, mainly in parts of immense stress or celebration (like when they finally land the crew safely), but I wouldn't call it excessive. Drinking is even less noticeable, maybe one scene in the beginning. There is quite a bit of language, but in reality, all the language said is from the actual speech said between ground control and the spacecraft, and it actually adds to the film as it further builds up the tension and stress of the situation.
The only thing I must say is that you do have to understand what is going on and be somewhat familiar with the space program to fully understand and enjoy the movie. If you have a kid and they aren't that familiar with anything space related, be prepared to pause the movie a few times to explain the setting, time period, and basically what's going on. The first time I viewed it when I was about 9 or 10 I thought it didn't make sense and didn't catch everything, but I still thought it was intriguing knowing just how close to death the main characters are. But I now understand every part very well, and every time I watch it again I learn something new.