I know it does wear off as we check the levels in postpartum women and administer a booster of the MMR vaccine to protect their next baby from Rubella.

There is always a small percentage that can also get it even if vaccinated but it is mild ( just like Covid)