First, just because a Pokemon is in a tier doesn't mean it has a "great performance" there. Venusaur is currently ranked higher in gen 9 UU than gen 8 UU despite not being in the gen 9 UU tier.
source
source
This was likely caused by Hippowdon dropping to UU in 2022, just a few months before SV released. Hippowdon made sun teams (including but not limited to Venusaur) worse, but many of the ladder players kept using sun teams until the generation ended.
source
source
However, Venusaur dropping from gen 8 UU would have made no difference, because it was banned in gen 8 RU. I think it's because several of Venusaur's threats in gen 9 RU, such as Blissey, Alolan Muk, Hisuinian Goodra, and Armarouge, either didn't exist or were above the RU tier in gen 8. (Entei is also a lot more common in gen 9 RU than gen 8 RU for some strange reason)
source
And of course, drought was banned in gen 9 NU, so Venusaur kept dropping after that.
So if you just look at viability and broken-ness and think of the Venusaur-drought combination as one thing, then it effectively just dropped from gen 8 RUBL to gen 9 NUBL. Venusaur dropped from gen 8 UU to gen 9 ZU because of a bunch of other things, like OU usage stats, Smogon tiering policies, and other sun abusers that were broken along with Venusaur in NU.