Add tag to query with hook_query_TAG_alter and filter for moderation state
EntityTypeManager does not allow for filtering through moderation states, although it is in the works for Drupal 11: https://www.drupal.org/project/drupal/issues/3025164#comment-13221005.