I had to be vaccinated to enter first grade, and again in college. Since I went to a public school, doesn't that already kind of answer this question?
Current Covid vaccines are non-sterilizing. They do not provide immunity that is equivalent to the MMR vaccine.
A future (nasal) Covid vaccine may offer long-term mucosal and blood/serum immunity.