So older garage doors open by shorting two wires together via a switch on the wall. The opener just looks for the circuit to be completed to signal the door to open or close.
This Zooz device, called a relay, is controlled locally by Hubitat. When you activate it (turn the relay on) it completes a circuit which signals the door to open or close much like the old-fashion wall switch. It is just a remote control switch.
Newer Security 2.0 doors add some complexity to that process, the wires that were a simple signal are now a complex encoded signal. You can't just touch the wires together and make the door open. But the idea is the same, you have to tell the door what to do, and this Zooz relay becomes part of that process. So the relay turns on, you tell an in-between device what to do, and that in-between device sends the encoded signal to the door. That in-between device can be a wall switch, an extra car remote, or a dedicated device.
It can totally replace MyQ if you want, or it could supplement MyQ so you have multiple control methods. It depends if you want both local and cloud base control, or one or the other.
If @Hubitat_Staff would be so kind to move this and Krishna's post above to the following thread, I would appreciate it.
Local Control Options for MyQ Garage Door Openers