She's pierside at 32nd Street in San Diego. You could try to tow her out past Point Loma, I guess, if the towing hawser itself doesn't part, and the "front fall off[1]" the ship, at the risk of bottling up the 3rd Fleet in the channel.
Ships can be rebuilt from extensive damage, as USS Cole, USS Stark, and USS Samuel B. Roberts show. It's a question of whether there is sufficient motive to do it, given the age and opportunity cost.
You can bet your bippy that everyone even remotely related to this disaster is going to get hammered when the investigation is completed. Military officers are held accountable in ways that politicians and bureaucrats (almost) never are.
[1] Yes, it's the "bow", but watch this humor clip => https://www.youtube.com/watch?v=gWPwlMv8lNI