The focus of that experiment was to find out of LSM-based storage[^1] would prove to be faster. It turned out that LSM, for SQLite's workloads, did not provide enough benefit to justify the upheaval.

[^1]: https://en.wikipedia.org/wiki/Log-structured_merge-tree