The memory tracker currently has complex logic to keep it alive throughout a query's lifetime. Since QueryLifespan was introduced, the memory tracker should live on that instead to simplify the memory tracker logic.