Foley said he saw The Rock’s “future expanding” when he first hosted Saturday Night Live.