Yes! Homemade pumpkin puree has more water content so it tends to be looser but for a soup that wouldn't matter. Small sugar pumpkins are the best type of pumpkin for making pumpkin puree (versus larger regular pumpkins). Substitute 3 1/2 cups of pumpkin puree for the canned pumpkin.