Benchmarking Threat Intelligence in Red Team and Purple Team Exercises: Data-Driven Insights for Security Testing