Leaving a pumpkin pie out overnight is fine and the pumpkin pie will still remain safe to eat the next day without refrigeration.
I've heard before that you should refrigerate the pumpkin pie when not eating or serving it to prevent bacteria from growing on the pumpkin pie.
Pumpkin pies are usually made with eggs, milk and cream which can go bad when left out longer than a few hours.
However while it's recommended to refrigerate pumpkin pie when not eating it within a few hours the pumpkin pie will remain safe to eat when left out overnight.
My Grandma and my mom and even myself have left pumpkin pies out overnight several times and they were okay to eat and nothing bad happened to us.