Do they raise stats depending on the form, or are the forms just for show?
Yes, they raise and lower stats according to the forms.
For example, Average Pumpkaboo has 49/66/70/44/55/51 stats, whereas Super Pumpkaboo has
Source: This website's Pumpkaboo page. If you like, look here.