CNO and pep solar neutrino measurements and perspectives in Borexino