True. For moderated nodes, The 'default revision' seems to be playing an impo...

True. For moderated nodes, The 'default revision' seems to be playing an important role and it makes sense to only keep 'published' & 'archived' states have default revision flag enabled(just what editorial workflow does).

I also tried to imagine creating the content page view from 'content revisions' and it's also not helping. As to fetch node data, Views creates 'joins' to 'node_field_data' table which only holds 'default revisions'.