Kayaks are long and skinny. The shells of giant pumpkins are think. I think you'd have trouble getting enough flotation. You need something with a better surface area to volume ration, a boat more like a hemisphere. I'm thinking a coracle mold. But then, that's basically what a giant pumpkin is already.