Radio AGN selection and characterization in three Deep-Drilling Fields of the Vera C. Rubin Observatory Legacy Survey of Space and Time