Deprecate legacy http endpoint

[MarinPostma]

The legacy HTTP endpoint has been superseded by the hrana protocol. I propose we remove it for clarity.

[psarna]

All of my demos use http 😅 it has this single advantage of being super easy to hand-code in a webpage

[MarinPostma]

I agree, I use is all the time for testing as well, and hrana is not very ergonomic, but at the same time, it's a maintenance burden :( Let's think about it

[penberg]

AFAICT the Fermyon Spin runtime uses the HTTP endpoint: https://github.com/fermyon/spin/blob/main/crates/sqlite-libsql/src/lib.rs#L12