The "Dry" in the brand's name refers to not being sweet, as in a dry wine. When John J. McLaughlin, who first formulated "Canada DryPale Ginger Ale", originally made his new soft drink, it was far less sweet than other ginger ales then available; as a result, he labelled it "dry".
A dry wine is simply a wine that has no residual sugar, meaning it isn't sweet.