#76222sys_category_record_mm doesn't get updated when deleting pages and records
Description
After deleting a page with some sys_category selected into the trash, the entry in sys_category_record_mm for that page is still present.
Even after erasing the page from the trash does not lead to an update on sys_category_record_mm.
The same problem exists with records of extensions. I have added a sys_category field by using \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::makeCategorizable(…) for that.
When I delete such an extension record the entry in sys_category_record_mm is still present. My first thought was that it is a mistake within the usage of makeCategorizable() by me,
but since this happens for pages as well this seems to be a bug/missing implementation.
Updating the reference index does not change anything, it tells me the integrity is perfect, which seems strange.
On long term this will lead to an exploding sys_category_record_mm table and inconsistent database state.
Relation to #63918 (was closed due to missing feedback)