It was sunk just after WWII during an Atomic Test. It sits upright in water that is not deep at all. In fact, she can be seen from certain overhead shots of the ocean.
I will NEVER EVER understand why she and ESPECIALLY the Enterprise were not saved to be Museums.