That's a great question! It's clear that not every melon type works for this, but it's also not clear how many would. According to an anecdote related in Foods & Folkways, the juice from the sort of melon they used was already pretty sweet, like even before processing your fingers would stick together from the juice. So it seems like a higher-than-usual sugar content is an important prerequisite in the type of melon used.