Capturing a Mode of Intermediate Water Formation in the Red Sea