These failures apply to every tablet that is not running a full desktop OS.
Of these the iPad is far and away the best option currently.
In addition to that, Android has had mouse support since at least 2012. It took Apple what, 8 generations to add it into iPad OS?
However, your overall point is correct. the Ipad is more successful as a "productivity" tool than Android among regular people, despite the suite of Microsoft Office apps being fairly similar in quality across both. I'm assuming that Office style apps are what's mostly being used, and not specialist apps like Procreate or Affinity which are iOS only.
My guess is that people are more willing to buy Apple for tablet productivity as their support is more reliably available and it's easy to get third party accessories. On the Android side there is no such guarantee. Samsung is only OEM even attempting to compete with the iPad Pro, but its support doesn't have the same reputation and accessories aren't always available in all markets.
For a device that didn't have a public file system until recently, the iPad's both works and makes sense. It's iPod, mobile phone, Bluetooth headphones all over again, on a feature level.
Except when it isn't. When you actually need to transfer a file from/to an Ipad to another device, and that you cannot access the file system and you don't have any other Apple device to do so, this is the hardest device to work with. I remember being honestly puzzled as to how to do it, and looking online for numerous "solutions", all of which involved installing more applications to hopefully do the trick. Pure horror. (It was, as far as I know, impossible to transfer files even thru a direct USB connection without any specific application - meaning USB was completely useless by default).