We'd love help in any of those areas! If you'd like to help with programming, take a look at [1]. For other areas, the processes is less structured and I'd suggest starting on our forums [2]. In both cases however, jump on our IRC channels if you have any questions (#0ad and #0ad-dev on quakenet).
In terms of where we most need contributors, at the moment I'm not aware of anyone working on campaign storyboarding or UI mockups.
[1] http://trac.wildfiregames.com/wiki/GettingStartedProgrammers [2] http://wildfiregames.com/forum/