And so can PvP. Any game will get repetitive eventually. But with a strong-enough gameplay loop, some element of progression, and an endless scale of difficulty, PvE could last you a good long while.
I’m still playing COD: World at War zombies to this day.