By default, all pages are given the order under Attributes of each page, placing 1- whatever, imputing the number the order you want. This is at the right had side of the post by clicking the cog wheel and under attributes.
If you haven’t placed that order while making pages, it can be time consuming to do, so there is a plug in to be able to drop n drag the order. https://www.ads-software.com/plugins/simple-page-ordering/
https://www.wpbeginner.com/plugins/simple-page-ordering-how-to-organize-wordpress-pages-with-drag-drop/
You sure do have a ton of pages and categories. In looking at them, it sure was overwhelming.
I know it took a bit for me to find a way to organize my files of recipes, poems etc and searched the plug in pages to find a method that would help organize them all. I know I used a plug in that gave me a widget that listed the pages within a category in a widget which helped with my recipes page. That was Category Posts in Custom Menu https://www.ads-software.com/plugins/category-posts-in-custom-menu/
I have a ton of recipes and to organize them all into categories and recipes i used this plug on one of my sites ex https://melsgraphics.com/category/recipes/ I have all categories in a menu and when clicked on the category pops up and then I had a menu for that category of all posts in that category. My recipes are my blog. But I was able to use a category for poetry and make a menu of all poems in a menu for that page too.
Unsure if this will help…
