The found issue is that In a debug build, the classic $group has a testing only behavior that always spills data which leads to an incorrect result even for unsharded collection. The updated test no longer depends on the unsharded collection for the expected results.