Nano 33 BLE Sense not detected via USB (even after 2-click RESET trick)

Indeed. Code is evidently running on the device.

Futhermore, if you can get that led into a pulsating mode with the double tap of the reset button you can also get into bootloader mode.

Why the usb port (they are different) for either of those modes is not seen by your computer is the mystery.