It is used just like the WP core user_search_columns filter https://codex.wordpress.org/Plugin_API/Filter_Reference/user_search_columns
The only real difference is that using the acf/fields/user/search_columns allows you to target only searches being done for an ACF field or specific fields based on field name or field key