CNBC host called on to resign after he used a misogynistic slur live on-air to Nancy Pelosi