Ex-senator, who has expressed regret over stepping down following accusations, says he was 'very gratified' that some of his fellow Democrats apologized for calling on him to quit