Fix Google Search Console indexing issues on large WordPress site (60K+ posts, ~420K pages affected)

BACKGROUND: We run a large WordPress celebrity biography/entertainment site with 60,000+ published posts. Google Search Console's Page Indexing report shows multiple issues affecting how pages are crawled and indexed (full breakdown below)... (Budget: $30 - $250 USD, Jobs: Apache, Cloudflare, Database Management, MariaDB, Nginx, PHP, SEO, Web Development, Website Optimization, WordPress)