[director] Fix snapshot fk violation when deleting a deployment [Fixes #49653727]