I think the importance of the trade value of having extra resources can't be overstated. This is the key reason to have them. If you are hurting for more happiness, you can trade an extra corn or two to other civs for their extra happiness resources, or vice versa. And you can trade them for money - the AIs will always trade you their maximum allowed gold per turn for any of your extra resources (this is kind of a bug I think, but whatever)... that gold can really add up. This is all assuming you are playing a relatively peaceful game with some other AIs (open borders, etc).