USB to Serial (RS-232) cable not displaying data on Arduino serial monitor
The adapter you bought has a USB UART chip with a RS232 voltage level translator inside the DE-9 connector, so the wires you cut use the USB protocol. You cannot connect USB to your Arduino, it will not work.