The sound was picked up from a National Oceanic and Atmospheric Administration device - roughly 900 miles from where the sub vanished in the south of Newfoundland in June 2023