You'll be fine for an overnight stop.
We live about 1hr west of there, been out for day trips, not camping but always do a drive thru in campground section. Entire area is sand, roads and campsites but they do have a small section of concrete by the picnic table.
Sites very wooded and private, pull thru's can be a little snug but saw all size 5'vers and motorhomes in the spots, just need to negotiate your rig for it's needs.
Quiet area and campsites are far enough away from day use and boat ramps areas, no bother.
2013 Sabre 32RCTS-6 (sold)
Family of 4 whose always on the GEAUX!