Cosmic evolution of low-excitation radio galaxies in the LOFAR Two-meter Sky Survey Deep Fields