Does Safety Cloud show the location of vehicles when lights and sirens aren't activated?

No. Safety Cloud only broadcasts digital alerts from equipped vehicles when lights and sirens are activated, including when vehicles are traveling and when they are parked on-scene or responding to an incident.