How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]

You should probably check out pre_post_update.

Use pre_post_update to check for a post update within your custom post type Container of Things. Check for your conditions. Then, get the connected Things and use wp_update_post to unpublish these posts.