Brand, now a convicted rapist, made the remark about Sir Rod's daughter, Kimberly during the 2006 GQ Man of the Year awards