Add memray_detailed_tracing option for deeper memory profiling (#65996)

https://github.com/apache/airflow/commit/26ee5c2fdc1aab93297818b69375c6b3a48708fa