The Next Generation Virgo Cluster Survey (NGVS). XXIV. The Red Sequence to ∼106 L⊙ and Comparisons with Galaxy Formation Models