Verified on 6.12.4 - Snap 2 Steps to Verify: Followed steps from the PR here:https://github.com/Katello/katello/pull/10391 These reproduced the orphaned content facet issue, and I was able to use the rake task foreman-rake katello:clean_orphaned_facets to clean them up.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Satellite 6.12.4 Async Update), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2023:2052