fix(server): clear activity when asset is removed from album

[dahool]

This is an alternative fix for #17475 as discussed in PR #18927

Schema checks will fail since I cannot update activity.table.ts since this change is not supported yet

Checklist:

• [X] I have performed a self-review of my own code
• [X] I have made corresponding changes to the documentation if applicable
• [X] I have no unrelated changes in the PR.
• [X] I have confirmed that any new dependencies are strictly necessary.
• [X] I have written tests for new code (if applicable)
• [X] I have followed naming conventions/patterns in the surrounding code
• [X] All code in src/services/ uses repositories implementations for database calls, filesystem operations, etc.
• [X] All code in src/repositories/ is pretty basic/simple and does not have any immich specific logic (that belongs in src/services/)