I Sorry, i made a mistake on the patch i uploaded on comment #11, i am uploading the right patch (3372217-12-media-entity-translations-status-published-unpublished.patch
We have a requirement to have unpublished media in all active languages, ready to be published eventually, but the current functionality requires to have at least one media translation published as it is stated in the "This translation is published" checkbox: "You must publish at least one more translation to unpublish this one. "
We created a patch (3372217-11-media-entity-translations-status-published-unpublished.patch) that has been tested in Drupal 10.2.2, PHP 8.1.26 and Mysql 5.7.42 successfully.
Thanks for this solution that has allowed us to solve our issues, it was causing struggle and confusion among our content managers. We are glad this is being worked on, and without a doubt we consider it convenient for future releases.