The AEM sites console http://localhost:4502/sites.html/content can list the AEM pages in List, Column and Card view.
To check the page status for example if the page is published or not, you need to click on individual page. Due to that the overall pages status in not visible in a glance.
Maximum number of AEM user use this view to navigate through the pages.
but none of the view gives more accurate information like
if the page is unpublished that means is it never published or unpublished later?
Whether the page is modified after the publish or before the publish?
And it is impossible to get all this information visually.
The same concern and improvement demand is raised by AEM Community User at https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager-ideas/published-status-visualization/idc-p/461069
What can be done to improve visualisation
The inspiration can be taken from classic UI to show color indicators or something new can be introduce.
At https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager-ideas/published-status-visualization/idc-p/461069 some ideas are proposed, If Adobe bring this change would be good for Authors