1. active dongle that gets digital audio signals from the phone, and converts that to analog using an onboard DAC
2. passive dongle that receives analog audio signals from the phone, and simply converts the pinout from usb-c to 3.5mm[1]
If you try to use the latter dongle on a phone that doesn't support that use case (ie. it doesn't contain onboard DAC), it will fail to work.
[1] https://en.wikipedia.org/wiki/USB-C#Audio_Adapter_Accessory_...
It specifically mentioned Pixel 4 compatibility.
Yes, I think it might work on a PC too, but I've never tried that.
Technically, this is more or less the same thing as what you linked to, just in a different form factor.
Or even this: https://www.alibaba.com/product-detail/5-1-Channel-USB-2-0_6...
Also same thing, but likely to have a crappier DAC.