I can not in good conscience try to assist with GoDaddy Apache anything, sorry. I know we do not discuss hosts around here, but that's a known, for decades. They just do things differently.
As for WP, there are two places to deal with WP URLs: first in the Admin> Settings panels because WP generates its own URLs based on how it is set up. The settings decide the URL structure, format and syntax. Physical pages do not exist, they are served from the database and syntax depends on the context and settings.
On a normal Apache host you can then add your rewrite rules *outside* of the WP snippet.
Do not edit the WP snippet in your htaccess file, as future versions/upgrades can overwrite that WP generated snippet.
WP snippet example:
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
That WP generated snippet of code belongs at the end of your rules, after any canonical/https rules.
When you get to actual rewrite rules, it is best to look through the thousands of examples in the
Apache [webmasterworld.com] forum where WP rewrite rules abound. I would not suggest relying on a plugin and the current rank math plugin has not been updated for the most recent WP version.
I agree with lammert that figuring out how to manage redirects/rewrites is the buyers issue because any answer that is functional today via plugin will not necessarily continue to function. The Yoast SEO plugin offers a rewrite function but it is not part of their free services and will be an ongoing cost to keep it chugging along. Hence the suggestion for careful planning and setup to be able to use your own 301 redirects.
