Callum Piper's pregnant partner watched on in horror as paramedics tried to save him after an asthma attack at his Stockton home