Disorder from order among anisotropic next-nearest-neighbor Ising spin chains in SrHo2O4