No, you can't. Most pumpkins are ornamental. To use fresh pumpkins for a pie, you need to purchase pie pumpkins. Although it's difficult to make fresh pumpkin puree, it's not for the beginner and definitely not something you should try without testing and practicing first.