Your hunch is correct. A colleague of mine, Bob Lucas, replied with the following answer:
"I went to this link.
From looking at the test statistic, I do not think it is possible.
The numerator of the CMH test is just the sum over all the strata of the observed minus predicted squared. The denominator is just the scaling factor so that the distribution is asymptotically Chi Square.
The numerator of the CMH test is similar to the numerator of the F in ANOVA. Consequently, I think it is a similar situation to overall F test in ANOVA vs. comparing two means in an ANOVA.
I think it is possible that in one stratum, there may be a significant association but none in the others so by averaging over all the strata, the one association is hidden. Similar to how two means in an ANOVA can be different but the overall F is not significant.
In ANOVA, if none of the pairwise mean comparison are significant, the overall F cannot be."