This is a bug that I have just fixed here:
https://github.com/discourse/discourse/pull/31507
We have introduced this feature because sites with over 1,000 categories had an unusable “/categories” page. Unfortunately, this introduced a bug because if a site has more than 1,000 categories, it will try to force lazy loading (or page by page) of subcategories too even when it is not the case.