That will work too. You just need to nest part of the query to that you can use “OR” for parts and use “AND” for other parts.
The problem with doing a lot of like queries is speed. More than likely the nested like query is overtaxing the connection.
I’m going to be honest with you here. If i needed to query a checkbox field I would convert the ACF values into a standard WP meta field. Although if could be difficult if you already have a lot of content on the site.
