Hello, what testing has been performed to determine that the temperature sensor is bad?
Your temperature sensor will not cause an engine overheating situation, where your coolant will purge from the vehicle.
Diagnostic testing is needed. It's impossible -- and not helpful -- to cover all possible scenarios in a forum like this without being able to perform hands on testing to find out what is happening with your specific vehicle.
You could have a thermostat concern, water pump concern, cooling fan concern, or more.
www.repairpal.com/repair-shops
RepairPal Certified shops can diagnose and repair your 2008 Porsche Cayenne. They provide transparent pricing with a minimum 12-month or 12,000-mile warranty on repairs and services.