The kinematics of globular cluster populations in the E-MOSAICS simulations and their implications for the assembly history of the Milky Way