Little Melody was struck down by a rare form of cancer usually only seen in middle-aged men