Exactly as described
For USB-C ondom
This does indeed let you make "charge only" cables.
My only gripe is this stops -just- short of solving the threat model of a typical BadUSB attack in an office environment where cables are often left unattended. An attacker can just replace the extension -after- this adapter with a customized c-to-c USB Ninja or similar when a target is not presently at their desk.
They will be trusting a usb condom with the attack resting on the other side of it in the short extension this adapter requires.
To mitigate this I would suggest a female-to-male variant allowing this to go directly between the end of a cable and the target device one wants to protect