Remove duplicate 'mock_supervisor_comms' pytest fixtures from core (#49457)

https://github.com/apache/airflow/commit/493402d24ece8c87b8004fa8a476b232408069cc