A 17-year-old passenger in a motorcycle crash in Rotherham has tragically died in hospital.