Sue Cleaver has opened up about her 'emotional' Coronation Street exit, with the Loose Women star's final scenes soon set to air