You are correct, unless you have a service-connected disability, received the Purple Heart, or were a POW.
Use of MWR facilities (includes campgrounds) is primarily for active duty, retired military, and DAV. Although, there are a few other categories that are eligible. However, military campgrounds are not a benefit provided to the typical veteran.