Double photoionization of simple molecules of astrochemical interest