when updating with weekly ROM - is data (sms, app data, pictures, ringtones, system settings,...) automatically restored or must I do backup/restore to get same data/settings back?
Yes in both cases weekly updating weekly and stable updating stable will keep data.
You can also dirty flash weekly on top of stable and not lose data, you cannot go back to stable from weekly, cause that's a downgrade of versions and will throw multiple errors.