trying connect my usb superdrive to my MacBook Air. need help

The linked adapter has no power of its own, it simply transmits power from the Mac's USB-C port. Although some USB-C docks specifically indicate support for the SuperDrive, most do not so indicate and most do not work. The amount of power the dock provides over USB-C is irrelevant, it's the power provided to USB-A ports that matters since that's how the SuperDrive must connect. Most hubs/docks cap the output current at 500 mA per USB-A port, and the SuperDrive draws 900 mA.

Here's my SuperDrive connected with nonda dongle and the disc in the drive properly mounted on the desktop – as I stated, works fine on 6 Macs.

https://support.apple.com/en-us/HT201736

What ports do you have on your MacBook Air? Use the above link to identify them.

That Amazon link is usually underpowered for devices like that. You'll want a USB-C hub with 100W PD connector if the Mac has only USB-C connectors.

You need a simple USB-C-to-A adapter. The SuperDrive needs close to twice the power draw of a standard USB-A device, and most hubs/docks and some adapters don't provide enough. I use a little dongle from nonda (Amazon link) and my SuperDrive works with 6 Macs in the house (4 MacBook Pros, 2 MacBook Airs).