A fan-favorite Coronation Street actor has opened up about the two 'heart-wrenching' parts of filming their tragic on-screen death