remove _pico_role and adjust system tables description

---

• Close #198 (closed)
• Target branch: main
• Changes should be cherry-picked to 24.1: no
• Staging: https://docs.binary.picodata.io/picodata/branch-.../