Andy Cohen, who admitted to being "overserved," made alcohol-fueled jabs during CNN's New Year's Eve Live special