How to unpublish a content after it has been moderated by a workflow?

Problem/Motivation

I have a moderation workflow that has the states: Draft, Under revision, Published. The content is unpublished until it the moderation is changed to Published state.

Sometimes the editors in my team need unpublish a content that has already been published. They change it to Under revision or Draft because they want to hide it from anonymous users or to be hidden from the public site but it is still available to everyone. If they try to remove it from publication from the content table (/admin/content) it doesn't allow them to.

I read here: https://www.drupal.org/project/drupal/issues/3100781 → that it is by design and that is ok for a regular use case but sometimes the content needs to be actually hidden from the site. So my question is how to unpublish and hide a node without leaving a public version. Is there a step I'm missing?

The workflow in my site is configured as:
Draft: Unpublished. Users in the content creation role can create content but just save it as Draft.
Under revision: Unpublished. Users with editor role can review and edit the content and change it to Published or return to Draft.
Published: Published. The content is available to everyone and published in the site.

Steps to reproduce

1. Configure a moderation workflow with unpublished and published states.
2. Create a content and save it with a moderation state.
3. Save the content as the published state.
4. Try to return it to an unpublished state but the content is still published.