Plan, which Gavin Newsom, the governor, has said would be ‘dead on arrival’, will allow six lease sales from 2027 to 2030