The AGN fuelling/feedback cycle in nearby radio galaxies – II. Kinematics of the molecular gas