Going by https://github.com/pgrok/pgrok/blob/main/internal/database/d... I don't think adding SQLite support should be that difficult. The ORM used (gorm) has SQLite support already.
Edit: this seems to be intentional to keep maintenance cost down: https://github.com/pgrok/pgrok/pull/11