I think the relative contribution of intelligence vs. practice varies substantially depending on the nature of the particular task.

This is true. Intelligence research has shown that intelligence is more useful for more complex tasks, see e.g. Gottfredson 2002.