Not necessarily. Quite often less "sophisticated" comedies are total dogs at the box office. It's just that Caddyshack was a particularly good one. Eldrick Woods' favorite film of all time, in fact. And a lot of other golfers who have a great deal of respect for the game love it as well. Just slapstick fun. I suspect it was cathartic viewing for Woods after his quite serious golfing childhood.
Maybe the turd in the swimming pool was a prophetic metaphor for his domestic life.