A Spectroscopically Complete Census of Faint Transients Observed by the Young Supernova Experiment