Yes, there are good reasons why a simple cable connection won’t provide the functionality that you seek.
USB isn’t just fancy electrical connector. USB, as a technology, is a much more complex system architecture.
The USB architecture requires a USB Host Controller and Root Hub to be present on the “host” device. A simple “cable” connection does not provide these active components.
iOS/iPadOS devices with a Lightning connection do not have a built-in USB Host Controller and Root Hub. The charging cable merely provides an electrical connection between your iPad and Power Adapter. However, when connecting your iPad to a PC/Mac computer, the computer (the “host”) has the required USB Host Controller and Root Hub with which to communicate with the connected iPad/iPhone.
When using an iPad or iPhone as a host device, it is therefore necessary to add the Controller components - and this is the significance of the Lightning to USB3 Camera Adapter.
The Camera Adapter is the key to connecting a Lightning equipped iPad or iPhone to other USB devices. The Adapter actively converts the proprietary Apple Lightning interface into a USB host device - and provides the USB Host Controller and Root Hub that are necessary to connect with (and control) USB accessories.
Prior to the introduction of USB-C, USB connections always had a Type-A connection for connecting the “host” device (i.e., the Host Controller) and a Type-B connector for the device being controlled (noting that Type-B connections where physically different to Type-A - and have evolved from Type-B through mini-B and micro-B).
USB-C connections (and system architecture) have again evolved. The physical connectors are now double-sided and bi-directional - and may have the same connector at both ends. Without delving into the complexities of USB-C (of which you’ll find many resources to research yourself), this is probably sufficiently adequate in context of your question.
So, to conclude, your iPad requires the addition of a USB Host Controller and Root Hub with which to communicate/control other USB devices - this functionality being provided by the Lightning to USB3 Camera Adapter.
I hope this description and clarification proves to be helpful - both explaining the USB functionality and requirements in basic language.