Studies of rare-earth magnetism and excitations in Kagome metals RV6Sn6 using neutron scattering