Pros:
Enough tree hazards and water hazards to keep things interesting, not so many to make it unenjoyable for beginners. The course is easy to walk. The holes are all close together. and there isn't a lot of pedestrian traffic that gets in the way.
Also, there's a playground that's within site of all the holes, if you want to bring some older children.
Cons:
There aren't any long holes. It probably won't be very challenging for experienced disc golfers, but it was great for beginners and casual disc golfers.
The course is adjacent to a baseball field and a decorative pond. We lost one disc rolling between a gap in the gate to the field (recovered) and two in the pond when we were goofing around trying for a longer drive (too deep to recover).