It can be both: I love being able to use Trilium "as a website" to check out my notes on other's (e.g. employer's) devices, and as a local first/fully offline/totally synced app during e.g. a flight trip or in case of an outage. The two just coexist and sync like a mesh.

https://triliumnotes.org/