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