If you are asking "why does the console information, which is based on SUMMARIZED information, which happens on a SUMMARIZATION schedule which is a black box mystery and cannot be triggered or modified, is different from the actual contents of the database, as seen in Resource Explorer".
Well, the information as exposed via the console is from SUMMARIZED information, summarized information happens on a blackbox mystery schedule, and will OFTEN be delayed from real data... because it is summarized information.
My advice is to simply don't believe the console, and use reports. The console is SUMMARIZED information.