That’s the frying mosquitoes (whining) sound when the 5 volt USB power from the computer is not “clean.” The microphone is combining your voice with electrical trash in the cable. There is an Audacity tool to help, but this noise is too loud.
https://forum.audacityteam.org/t/usb-whine-filtering-yeti-curse/45601/35
Neither the microphone nor the computer may be broken, but they’re a bad match. The maker of the microphone left out the parts that can manage bad USB power. The maker of the computer left out the parts to make clean USB power.
This is most likely to happen when they’re both affordable. They can’t both leave out parts.
Does the sound change if you make recordings with the computer plugged into the wall and then try again on battery power?
Koz