Never mind.
I created a redirect for my site.
Apparently, the wp_options table must have the actual siteurl and home values. Meaning, they cannot be the redirect-from URL.
If your site is: https://www.neogecko.com/NRI which redirects to https://www.neogecko.com/wordpress, then the siteurl and home values in wp_options must be https://www.neogecko.com/wordpress.
