Update insights backend docs with new database state

Created by: leonore

closes #32858 (closed)

• Update database sections in developer docs for insights
• Remove outdated mentions of TimescaleDB
• Update architecture diagram

Test plan

sg run docsite

to make sure docs are looking as expected