Thanks for your reply.
For the Preview Mode, none of the supposed-to-be-matching-to-the-rules files are showing up (the list is empty).
For Hazel.log, I tried to execute the rule many times today, but there are no entries in the log that reflect today's date. All the entries are from yesterday and they are for other rules that work fine (not this rule I'm having trouble with).
For seeing what Hazel (and Spotlight) sees, I followed the steps and this is what I got.

It looks like Hazel is not seeing the resolution since the DPI resolution is 0 for both height and width. I tried the terminal command for another file with different resolution and the DPI resolution is the same, 0. Since I'm using "resolution width" and "resolution height" in the rule, it was looking at the DPI which is 0.
Therefore, I switched the rule to "Pixel width" and "Pixel height" instead and viola. It worked like a charm
I'm reporting the above for the next person who experiences a similar issue.