Follow-up from "Cleanup attention request related system notes"

We need to remove the temporary index tmp_index_system_note_metadata_on_attention_request_actions which was introduced in !97753 (merged)