I think the most important part is
Using only Liquid, you will sooner than later be confronted with the issue. I would advise to design a web-component that will provide the desired behavior. For example, you could keep using your paginate setup, having 250 articles IDs via Liquid and the web-component Javascript would fetch the other articles.
Without more context, that’s the most I can tell you but Liquid will only get you so far if you go beyond 1000 articles.
You can check this post and see if you can translate the code to use articles 