Just as a note, twice now you've said the word "generally" and provided the same link, one person's blog representing his own opinion. That's not what the word "generally" means.
You can say "one person has the opinion that Yarn is not required anymore". But saying "generally" means it's common knowledge and most people would agree with that opinion. That doesn't seem to be the case here.
I don’t think this is true. It just depends on what your requirements are. If you use monorepos anywhere Yarn is a better default everywhere so you use its cache. PnP should solve one more huge problem in the near future too.