Things can be brought out of mothballs, Its all down to necessity and desperation.That's what a Mothball Fleet is for. If a ship is turned into a museum, there will never be a need for it to reenter service again.
A good hull, a team of savvy engineers, some spare parts and you've got a functional ship for light duties or minimal combat. The Hathaway was reactivated for a similar purpose.