Asian rice vinegar is the most similar, so is the best substitute. You can also use white wine or sherry vinegars - although they're a tad more harsh. Red wine or apple cider vinegars can also be substituted, but they've both got much heavier and less sweet flavor than champagne vinegar, and they'll also alter the color of your pickles slightly.