The documentation states that "The $in operator is analogous to the SQL IN modifier, allowing you to specify an array of possible matches."

But it appears to also work when applied to an array in the database. The documentation should define exactly what $in means when both argument and database are arrays.

The behavior appears to be any element in the database array field is $in the query array.