Pros:
Former ball golf course, so a very picturesque course (right next to the Tennessee, to boot), and plenty of room for some long roomy fairways. Trees in play are almost all tall pines, which are well-established, so getting a disc stuck in a tree is unlikely. Clever usage of former greens as either tee locations or, uh, greens adds elevation to an otherwise level course. Water hazards help spice things up, adding some risk/reward calculations for most players. The long tees actually do play quite differently from the shorts.
Cons:
Nicknamed the Swamp, which is only funny because it's true. Casual water happens (this past winter/spring, hole 3 had the same casual water standing for several months without interruption), and will get your feet wet. The water hazards are downright fetid, managing to be both overgrown with vegetation and yet still littered with dead plants. Discs that splash down and sink are unlikely to be visible, even from directly above. There's no telling what you might find in the ponds (aside from the concrete blocks of their formerly upright retaining walls) - hole 4 has 1.5 pairs of my sandals, and I found an old tee sign in hole 2's pond once. On a related note, the park occasionally floods outright.
Recently I've noticed a very few snakes in/around the water. While less dangerous, the geese are also nuisances by way of leaving little messes all over certain tee pads.
My only serious issues not related to water are the relatively open nature of even the wooded holes and the lack of more serious elevation changes - both of which are limitations pretty much inherent in the land, to be fair, rather than design issues.
Other Thoughts:
Hole 6 does not have a separate long tee. All other holes do.
The morning dew is very heavy, and can really bog down early rounds. Midday heat in summer is harsh, given the relative lack of shade on most holes and high humidity, but it also means you'll have the course more or less to yourself.
The tees, while carpet, aren't bad, since they don't tend to get muddy or mossy. Concrete is always nice, but these don't pose any issues.