I got it working again. I think I had an older board package installed in IDE 2.2.1. I reprogrammed the board in IDE 1.8.19 with a blink sketch after reloading the board packages. Now I'm able to see it as a device again as an Arduino IoT cloud device.
The rp2040 chip has a basic bootloader in ROM, that will show up as a Pico, if everything else fails. The local IDEs should know how to upload to it anyway, possibly requiring a bit of a dance with a "boot" button and plug-in.
I had a similar problem after uploading the incorrect version of the micropython UF2 file through Thonny. I inadvertently installed the pico micropython and gave me the same problem you had; however, the bootloader would not work since it is configured differently in the pico.
I solved that by dropping the UT2 file into the bootloader, and I loaded the boot loader using the bootloader() command.