Yes upgrading the ram to 2gb will definitely move things along faster.
That model can take 4gb of ram though 2 would be more then enough.
I assume it's running XP and with more ram it will be viable for surfing and other apps.
I think it's still worth it till 2012 when XP becomes unsupported.
I'm still running an older Dimension with a P4 and 1gb of ram supported and it's fine for internet activities.