The loft area is a sauna during the day, you'll start sweating immediately and literally have a heat stroke if up there for too long. I installed 2 tiny gable vents at the front / back for airflow but I cant tell a difference.

Im preparing to install foam boards between the rafters for my roof insulation (2nd pic), this will leave a 1.5" air gap between the metal roof and foam board.
Would this alleviate my pizza oven loft area and keep the hot air outside or are there venting options I should look in to? Theres a lot of debate on forums about different techs and ways to approach this.
BTW the metal roof ends are completely sealed off to protect against the elements / insects.