The sorting options in the report builder aren’t persistent through pagination.
We can contribute with a PR but needs some help from frappe team that is involved in the new datatables.
Issue with gif: Sorting in Report Builder · Issue #7766 · frappe/frappe · GitHub
Thanks