A motorist passed away following an incident on a South Yorkshire motorway, despite the heroics of an off-duty police officer who stopped to help.