The ones in Corpus and Charleston are promoted as part of the local tourist industry. The Intrepid is also fairly well known. The one in San Francisco Bay I would not have known about except for Googling to confirm names on the others.
Most of the BBs are also fairly widely promoted. Wilmington, Mobile, Houston, Pearl Harbor, and Norfolk. The New Jersey and the Massachusetts are probably less well known. (In fact, I don't recall if they ever settled on a final home for the New Jersey.)
The DDs and the subs usually are only known locally. Here are some lists if you are interested. http://www.hazegray.org/navhist/preserve.htm
The Norfolk one I saw. That was a fun tour.
The grammar schools that are local to these carriers should make them a part of their history classes.