Investigate the flakiness of the unit tests failing during nightly builds

[ElenaKhaustova]

Description

#4348
#4349

Specific unit tests are constantly failing during the nightly builds which is usually fixed by several re-run attempts. For example:
tests/framework/session/test_session_extension_hooks.py::TestNodeHooks::test_on_node_error_hook_parallel_runner

We suggest investigating why it's happening, making sure these tests are relevant and consider replacing them to avoid undefined behaviour.

Context

It slows down the development and takes extra time for manual re-runs when wizarding.

[astrojuanlu]

Example: https://github.com/kedro-org/kedro/actions/runs/11991462849/job/33430083296

Unclear if this can be reproduced locally or just happens on CI

[merelcht]

Will monitor builds first before determining this is done.