Unlike a lot of other "science fiction" books/stories, Andy Weir seemed to make a genuine effort to get as much right as possible, and did his best to drag along the film producer. If all of science fiction was at this level, it would be a miracle. And as you've pointed out, where the science does fail, it fails in such a way as to spark discussion and interest in the real science. I don't feel like my intelligence was insulted after having watched/read it, or that errors and omissions were a result of laziness or "the audience is too dumb/doesn't care anyway, so why bother". (Although the book was better than the movie in that regard.) If anything it served as a launching (punnnns) point for learning more about growing food on Mars and other similar problems.