Sensitivity to neutrinos from the solar CNO cycle in Borexino