[Waiting for user feedback] Large Sync with Crowdin is completely stuck with missing pages

<b>Background of the issue: </b>
I am trying to sync a large number of translation jobs on my site, hidden link, using Crowdin's API. We have a global scope and a very large site, with approximately 250,000 translation jobs to do. I've performed AI translation on them using Crowdin's API, and some have popped up, but mostly they all seem to be stuck now. Previously, I used ATE and switched to CTE, restarting completely fresh, but encountered issues once there were more translation jobs. I've tried pressing the no/very-low risk troubleshooting buttons. Some database queries seem to be taking a long time. Here's the Crowdin project: hidden link Here are some of the queries: require('wp-admin/menu.php'), wp_count_comments, get_comment_count, get_comments, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->get_comment_ids, QM_DB->query #121 (52.2 ms) SELECT COUNT(*) FROM wp_comments JOIN wp_icl_translations icltr2 ON icltr2.element_id = wp_comments.comment_post_ID JOIN wp_posts ON wp_posts.ID = icltr2.element_id AND CONCAT('post_', wp_posts.post_type) = icltr2.element_type LEFT JOIN wp_icl_translations icltr_comment ON icltr_comment.element_id = wp_comments.comment_ID AND icltr_comment.element_type = 'comment' WHERE ( comment_approved = '0' ) AND icltr2.language_code = 'en' AND (icltr_comment.language_code IS NULL OR icltr_comment.language_code = icltr2.language_code) do_action('load-toplevel_page_tm/menu/main'), WP_Hook->do_action, WP_Hook->apply_filters, WPMLUserInterfaceWebInfrastructureWordPressCompositionRootConfigAdminPage->WPMLUserInterfaceWebInfrastructureWordPressCompositionRootConfig{closure}, WPMLUserInterfaceWebInfrastructureCompositionRootConfigConfig->onLoadPage, WPMLUserInterfaceWebInfrastructureCompositionRootConfigConfig->loadScripts, WPMLUserInterfaceWebCoreComponentDashboardApplicationDashboardController->initialScriptData, WPMLInfrastructureWordPressComponentTranslationProxyApplicationQueryRemoteJobsQuery->getCount, WPMLInfrastructureWordPressPortPersistenceQueryHandler->querySingle, QM_DB->query #183 (136.3 ms) SELECT COUNT(*) FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_icl_translations icl_t ON icl_t.element_id = tt.term_taxonomy_id AND icl_t.element_type IN ('tax_category') WHERE tt.taxonomy IN ('category') AND ( ( icl_t.element_type IN ('tax_category') AND ( icl_t.language_code = 'en' OR 0 ) ) OR icl_t.element_type NOT IN ('tax_category') OR icl_t.element_type IS NULL ) do_action('toplevel_page_tm/menu/main'), WP_Hook->do_action, WP_Hook->apply_filters, WPMLUserInterfaceWebCoreSharedKernelConfigPage->render, WPMLUserInterfaceWebCoreComponentDashboardApplicationDashboardController->render, WPMLUserInterfaceWebLegacyComponentDashboardDashboardTabs->wrapTabsAroundContent, WPML_TM_Menus_Management->renderEmbeddedDashboard, WPML_TM_Menus_Management->render_main, WPML_TM_Menus_Management->build_tab_items, WPML_TM_Menus_Management->build_translation_jobs_item, WPML_TM_Jobs_Repository->get_count, QM_DB->query #219 (820.2 ms) SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type FROM wp_icl_translations wpml_translations JOIN wp_term_taxonomy tax ON wpml_translations.element_id = tax.term_taxonomy_id AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN wp_icl_translations tridt ON tridt.element_type = wpml_translations.element_type AND tridt.trid = wpml_translations.trid WHERE tridt.element_id IN(189). I've read forum posts about Crowdin, which is where I learned to use CTE and figured out what troubleshooting buttons were safe to press.

<b>Symptoms: </b>
The large sync with Crowdin is completely stuck with missing pages, and most translation jobs seem to be stuck.

<b>Questions: </b>
Why are the translation jobs stuck?
What can I do to resolve the issue of missing pages during the sync? - A few basically are back in that first state where they say they have not been sent for translation.
Are there any specific troubleshooting steps I should follow for large translation jobs?
Is it a problem where I need to optimize the database and what would be the steps if so?