fix(tracing): Fix span nesting concurrency issues #2512

Job	Run time
Cloud (latest) (3.8, ubuntu-22.04)	1m 41s
Cloud (pinned) (3.6, ubuntu-22.04)	2m 19s
Cloud (latest) (3.12, ubuntu-22.04)	2m 9s
Cloud (pinned) (3.8, ubuntu-22.04)	3m 54s
Cloud (pinned) (3.13, ubuntu-22.04)	4m 43s
Cloud (pinned) (3.7, ubuntu-22.04)	3m 29s
Cloud (latest) (3.11, ubuntu-22.04)	1m 20s
Cloud (latest) (3.13, ubuntu-22.04)	2m 49s
Cloud (pinned) (3.12, ubuntu-22.04)	2m 5s
Cloud (pinned) (3.9, ubuntu-22.04)	4m 18s
Cloud (pinned) (3.11, ubuntu-22.04)	3m 30s
All pinned Cloud tests passed	2s
	32m 19s

Provide feedback