Even though you have it plugged into your Insignia adapter, the SuperDrive usually won’t work through most third-party USB hubs or adapters. Apple designed it so it draws a bit more power than a standard USB accessory, and for that reason it needs either a direct Apple connection or a special adapter.
For your MacBook Pro, the best solution is to use Apple’s USB-C to USB Adapter (model number MJ1M2AM/A). That’s the one adapter guaranteed to provide the right power and handshake for the SuperDrive. Plug that directly into one of your MacBook’s USB-C ports, then connect your SuperDrive into it. Once it’s connected properly, macOS should recognize it automatically without needing any drivers.