I really enjoyed visiting the USS Hornet Museum in Alameda, California last month. The ship is not usually crowded during the week, and knowledgeable guides are available to take you through the areas that are not available on a self-guided tour. In addition to a mix of aircraft from WWII through the 80's, there is also an Apollo splashdown display. The Hornet was the primary recovery ship for the Apollo 11 moon mission, and also recovered the crew of the Apollo 12.
If you plan to visit to take photos, note that large bags are not allowed because you have to climb up and down some steep, narrow staircases to access parts of the ship. Even a 2-3 hour tour is barely enough to scratch the surface of all the cool things to photograph on board. Enjoy the photos!