Update. I am an idiot.
Once I removed the "Realtek" driver that I was trying to use, and installed the "RaLink" driver that the card needed, it works like a charm. Sorry for the wasted time and effort.
I guess from now on, the first question to me should be "Are you an idiot" to which my reply will be, "Yes".