Is it true that DOD Civilian Retirees may be authorized access to MWR activities, such as RV Parks, Campgrounds, etc?

Yes, in some cases, and when specifically authorized by the installation commander. Please see the document linked below for more details:

DOD Civilian Retiree ID Cards