The latest novel by Irish-American author Mary Beth Keane, exploring what happens behind the closed doors of two NYPD families, has catapulted her into the cultural conversation, writes Esther McCarthy