The Select geoprocessing tool does not return the expected outputs when the input feature layer contains an active selection in addition to the clause.
The Select tool uses an existing selection and executes on it. This tool includes a toggle below the Input Features parameter to ignore the selection. This feature is available in ArcGIS Pro 3.3.