Use asyncio for async operations in Runners

[merelcht]

Description

We can refactor the code in Task that handles asynchronous loading and saving of data to use asyncio.

Context

#4206 (review)

[astrojuanlu]

The idea is to refactor this method here:

kedro/kedro/runner/task.py

Lines 192 to 198 in a1fae50

	def _run_node_async(
	self,
	node: Node,
	catalog: CatalogProtocol,
	hook_manager: PluginManager, # type: ignore[arg-type]
	session_id: str | None = None,
	) -> Node:

Possible inspiration:

• https://www.roguelynn.com/words/asyncio-we-did-it-wrong/
• https://vorpus.org/blog/notes-on-structured-concurrency-or-go-statement-considered-harmful/
• https://docs.python.org/3/library/asyncio-task.html#task-groups (added in version 3.11, ugh)
• https://anyio.readthedocs.io/en/stable/tasks.html

We set an appetite of 1 sprint but we might need another one to wrap it up.