A man died following a residential explosion on Clifton Mount in Rotherham, prompting multi-agency emergency responses and ongoing forensic enquiries.