It rained the whole weekend, but we still had a great time!
So it rained during set up and it rained during take down. It stopped raining for a bit and we took a nice walk around the campsite, out to the lake and back. Then night fell and so did the rain. Listening to the rain drops fall all night long was a treat. Getting up to move the air mattresses to avoid the rain inside the tent was also a treat.
We knew ahead of time that it would rain all weekend. We also knew our large 20'x10' tent was a bit old, so we brought a GIANT 20'x16' tarp to keep out the rain. It worked for most of the weekend. We were more worried about pitching the tent at the bottom of a slope since the campsite has a small incline, but we didn't wake up in a pond or even much of a puddle. There was a bit of mud we tried to avoid tracking into the tent, but otherwise this site was okay for tents in the rain.
This is a large pull-through trailer campsite, right across from the restrooms with sinks/shower. Water is down the road a bit, not by the restrooms. There is a campsite right next door and their firepit is 15-20 feet away from where we pitched our tent, but it stayed empty that weekend. Traffic to the restroom as constant, and close by, so not very private/secluded.