The effect is the animation. The palette is the set of colors that may be used by the effect. With the caveat that effects may use colors differently. Most use palettes; some use the primary, secondary, tertiary colors you select; some use a combination; and a few ignore all of that and have hard coded colors.
If you look at the effects and palettes page you can tell which uses palettes (Party a rainbow) vs colors (orange and yellow)