Asymptotic work statistics of periodically driven Ising chains