Fix scheduler transition error on `memory->erred`

[hendrikmakait]

Closes #8548

• [ ] Tests added / passed
• [ ] Passes pre-commit run --all-files

[github-actions[bot]]

Unit Test Results

See test report for an extended history of previous test failures. This is useful for diagnosing flaky tests.

    27 files  +    1      27 suites  +1   10h 8m 49s :stopwatch: + 47m 57s  4 050 tests +    2   3 935 :white_check_mark: +    2    110 :zzz: ± 0   5 :x: ±0  50 854 runs  +2 615  48 488 :white_check_mark: +2 531  2 335 :zzz: +84  31 :x: ±0 

For more details on these failures, see this check.

Results for commit 449f447e. ± Comparison against base commit e16a7af1.

:recycle: This comment has been updated with latest results.

[hendrikmakait]

@crusaderky: All comments have been addressed.

[crusaderky]

LGTM, however I have no idea if there are any regressions. Do you want to merge it now or would you rather wait for https://github.com/dask/distributed/pull/8560?