From Galway to NI, the island’s darkest secret shows that church and state failed the most vulnerable people for decades