The problem with altering the search query is that the search word would need to be in:
(title OR content) AND $custom_field
and this is why no results are returned, because the search terms are likely not in both places.
Here is an explanation on how to do what you’re trying to do https://adambalee.com/search-wordpress-by-custom-fields-without-a-plugin/
