Emmerdale fans ‘sick to their stomachs’ as ‘sad’ exit is sealed