Move the ship to some place like Texas or South Carolina instead of the Left Coast and problem solved.
Hornet's problem is it's isolation. As far as anyone can tell, the only activity at the former Alameda Naval Air Station is the Hornet and Myth Busters TV show.
The USS Pampanito is at Fisherman's Wharf in San Francisco (Yeah, that San Francisco). It does a great business, primarily because of all the foot traffic. It is an exceptionally well-cared-for boat, and people love it.
As the article points out, the cost of moving Hornet is prohibitive. The real answer is development in the area.