It depends if you're using them all. Systems where I have lots of applications installed (especially graphical ones) will have lots of packages, my bare-minimum container hosts will have few. I think there's also an element of selection bias here, because people posting screenshots of neofetch on their system are also likely to be people who intentionally run very minimal systems focussed on minimizing the number of packages so they can brag about it on the internet.
TL;DR - the right number of packages to have is as many as are required for your computer to do what you need it to do, and not too many more than that.
While I find that I agree with his takes like, 55% of the time, I do agree that Debian and Arch are basically the S-tier distros. So many of the other ones are basically just opinionated Debian or Arch, and while those can be useful when you’re getting started, I’ve found that for the long haul you’re better off just figuring out how to configure the base distribution with the elements of the opinionated ones that you like rather than use those distros themselves. Also, RIP CentOS. I would have put that in a high tier before the RHELmageddon (not top tier mind you, but it had a well defined use case and was great for that purpose).