RAW, it would seem that any creature becomes a medium zombie
The spell's description does not place any restriction on the target regarding creature type or size, and yet it does specifically say that they are raised as a zombie, pointing the player/DM to the zombie entry in the Monster Manual.
It seems that a RAW reading would imply that any creature of any type or size would somehow come back as a medium zombie.
A DM can rule otherwise
Although this goes without saying for most Q&As on this site, I feel like it's worth pointing out that a DM would be strongly encouraged (by me, at least) to rule something more sensible.
For example, if an ogre were killed by this spell, it would make more sense for it to be raised as an ogre zombie instead of a regular zombie. If some other creature that doesn't suit a regular zombie were to be killed by this spell, the DM can come up with a similar zombie monster that better suits the creature that was killed.
The DMG (pp. 280-281) has a "Monster Features" table showing what sorts of changes could be made to a creature, similar to a template (but not quite as per the templates in the Monster Manual), that a DM can use to convert a creature into a zombie-version of that creature.
Alternatively, if the DM would prefer to maintain the balance of keeping it as a CR 1/4 zombie, it could simply be the stats of a zombie, but of the appropriate size (rather than Medium) and narrated as being more similar to the creature that was just killed.