Pumpkin (Cucurbita maxima) is an important vegetable crop of the Cucurbitaceae plant family. The fruits of pumpkin are often used as directly edible food or raw material for a number of processed foods. In nature, mature pumpkin fruits differ in size, shape, and color. The Atlantic Giant (AG) cultivar has the world’s largest fruits and is described as the giant pumpkin. AG is well-known for its large and bright-colored fruits with high ornamental and economic value. At present, there are insufficient studies that have focused on the formation factors of the AG cultivar. To address these knowledge gaps, we performed comparative transcriptome, proteome, and metabolome analysis of fruits from the AG cultivar and a pumpkin with relatively small fruit (Hubbard). The results indicate that up-regulation of gene-encoded expansins contributed to fruit cell expansion, and the increased presence of photoassimilates (stachyose and D-glucose) and jasmonic acid (JA) accumulation worked together in terms of the formation of large fruit in the AG cultivar. Notably, perhaps due to the rapid transport of photoassimilates, abundant stachyose that was not converted into glucose in time was detected in giant pumpkin fruits, implying that a unique mode of assimilate unloading is in existence in the AG cultivar. The potential molecular regulatory network of photoassimilate metabolism closely related to pumpkin fruit expansion was also investigated, finding that three MYB transcription factors, namely CmaCh02G015900, CmaCh01G018100, and CmaCh06G011110, may be involved in metabolic regulation. In addition, neoxanthin (a type of carotenoid) exhibited decreased accumulation that was attributed to the down-regulation of carotenoid biosynthesis genes in AG fruits, which may lead to pigmentation differences between the two pumpkin cultivars. Our current work will provide new insights into the potential formation factors of giant pumpkins for further systematic elucidation.