On the stability of time-periodic pipe flow