ITV Coronation Street has finally revealed the fate of one major character