The main difference lies in the base ingredient. Sweet potato pie is made with cooked and mashed sweet potatoes, while pumpkin pie is made with pumpkin purée.