Unfortunately, the StreamDeck doesn't emulate a standard USB HID device, so it needs a driver running in the background to detect button presses and do things like generate keystrokes or call Keyboard Maestro macros.
There's streamdeck-ui (https://timothycrosley.github.io/streamdeck-ui/), which is an open-source alternative, but it at first glance it seems to be only for Linux.
There are a bunch of other macro/launcher pads like the StreamDeck that DO act as standard USB HID keyboards, though, and those should work fine with Keyboard Maestro using keyboard shortcut triggers.