The effective collation on $lookup can be set through various means (_internalCollation property on $lookup stage, collation property on the pipeline, collation of the local collection) and might not match the collation of the index of the foreign collection. In this case we should fall back to using NLJ/HJ algorithms.