The sites are small. No campfires. Not picturesque. I think the draw is the proximity to Nashville - VERY close to Opry Mills Shopping Center (which has the standard shopping mall stores, and a few unusual ones) and Opryland Hotel. Maybe a 5 minute walk from Nashville's Camping World (that one hasn't closed, has it?).
Here is a link to RVPARKREVIEWS.COM for Two Rivers: http://www.rvparkreviews.com/regions/Tennessee/Nashville.html
Here's the satellite photo from Google Maps (campground location is the reddish A):

.