Viewers of the ITV soap were left in tears over his heartbreaking last comments