Is sweet potato pie really pumpkin pie?

No!!!

No; sweet potato pie is made with sweet potatoes and pumpkin pie is made with pumpkin. They are two different ingredients.