[lite] default to pipelining appends and remove `S2LITE_PIPELINE` knob

[shikhar]

Improves performance a lot against high-latency object storage

Depends on slatedb/slatedb#1138

[shikhar]

To enable it for now, set S2LITE_PIPELINE=true