Raw pumpkin puree will not have the same smooth and soft consistency, so you'll definitely want to roast it first so that it's not so stringy and fibrous. Cooking the pumpkin will result in a sweeter taste and will be much easier to puree in a food processor.