Actor says he was thrilled and honoured to share his story with one of the most famous talk show personalities