The Coronation Street star has shared how an appearance on a popular show was his "worst" moment in television