How to reliably connect Apple USB SuperDrive to iPad Pro m5?

Unfortunately, basically using a SuperDrive with your iPad Pro will not work (even with adapters).

Why?

• iPadOS does not support optical drives.
• Practically speaking, even if you connect the SuperDrive with a USB-A ↔︎ USB-C adapter (or via a hub), iPadOS won’t recognize it as a usable storage device.
• The official documentation for the SuperDrive only mentions usage on Macs, via a USB-A port (or USB-C → USB-A adapter on newer Macs).
• The SuperDrive is known to draw more power that typically can be provided by a standard USB-A (or USB-C) port. However, power is the least concern with using this drive with your iPad.

The bottom line?

If the goal is to read/write CDs or DVDs from the iPad Pro M5, there’s basically no reliable way using the Apple SuperDrive. Instead you’ll need alternative approaches:

• Use a Mac or PC to read the optical disc contents, then transfer the data (files, media) via cloud, external SSD/USB-C drive, or network onto the iPad.
• Acquire a third-party external optical drive (USB-C powered, or externally powered) that is explicitly designed for generic OS compatibility. Many of those behave more like standard USB mass-storage devices and have a better shot at working (though still no guarantee on iPadOS).
• If the goal is media playback (like movies), consider ripping/encoding the disc on another machine, then using a media-file compatible with iPadOS.

iOS/iPadOS fundamentally does not support connection of any optical media drives - including the Apple SuperDrive. As such, direct access to optical media (CD, DVD, BD) from iOS/iPadOS devices is not possible.

You’ll need to access this optical media using another computer, such as PC or Mac.

You cannot.

iPads have no support for optical drives.

There's no place on the iPad to even open and view an inserted CD or DVD.