Pumpkin spice is only the flavor of the spices added to a pumpkin pie. Pumpkin pie flavor (should) taste like the pie filling in total. It’ll be a sweeter smoother flavor. Most of the spices you put in are fairly sharp flavors, so the pumpkin evens it all out.