Add async span context manager #8414

Job	Run time
Common (pinned) (3.7, ubuntu-22.04)	2m 53s
Common (pinned) (3.11, ubuntu-22.04)	4m 49s
Common (pinned) (3.10, ubuntu-22.04)	4m 45s
Common (pinned) (3.8, ubuntu-22.04)	4m 31s
Common (pinned) (3.12, ubuntu-22.04)	4m 40s
Common (pinned) (3.9, ubuntu-22.04)	5m 42s
Common (pinned) (3.13, ubuntu-22.04)	4m 27s
All pinned Common tests passed	2s
	31m 49s

Provide feedback