The best pumpkins for pie are heirloom culinary varieties with dense, sweet flesh that's not watery or stringy. Some of the best pumpkin for making pumpkin pie include Fairytale Pumpkins, Jarrahdale Pumpkins, Dickinson Pumpkins, Long Pie Pumpkins, and Red Kuri Squash.