After six of the eight founding members left the Net-Zero Insurance Alliance, Joshua Geer investigates if their ambitions stand