We are nearly at the end of iOS 17’s release cycle and Apple still has not fixed the bug in Mail where the All Inboxes view does not show huge numbers of recent emails.
Mine keeps loading today with a near three-month gap in which messages are visible.