@JRichy 

Hi,

Can you successfully connect to that Wi-Fi network when using the password method instead of the WPS method? Or does that fail as well?

You could test if it works better with the latest available driver for your adapter.
https://station-drivers.com/index.php/en-us/component/remository/Drivers/Realtek/Wireless-(Wifi)/RTL8192RU-8188CU-8188CUS-8192CU..../Realtek-RTL8812AU-8192RU-...-Version-1030.44.0822.2023-WHQL/lang,en-us/
(this driver package contains support for "USB\VID_2357&PID_0109", which should be the hardware ID of the TP-WN823N)