Yes, Express will quite capably share your net connection, and also provide you with AirTunes (to play music to your stereo wirelessly) and USB printer sharing wirelessly.
Airport Extreme seems to be being phased out and/or more targeted towards schools/offices. IIRC it can have a 56kb modem in it, and an extra ethernet port.
Go the express.