The MS Aurora, which inspired "The Love Boat," has sunk in a Northern California estuary, causing concerns about drinking water. Its mysterious demise has left officials puzzled, with the focus on environmental and safety issues rather than its glamorous history.