Avoid that content_moderation uses overrides as default revisions

Dominik Willerequested to merge
issue/sites_content_overrides-3584915:3584915-content-moderation-compatibility into 1.x

Closes #3584915

Merge request reports