You could try to index your column and use caml to filter all items which meet your requirement. Then delete them one by one.
Reference:
Overcoming the List View Threshold in SharePoint CAML queries
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.