When deleting a segment, do a soft delete instead of a hard delete #14826

We already have a flag deleted in segments. When we delete a segment, it should actually keep the segment entry instead of deleting it fully. This allows us to better delete orphaned segments from archives etc. We should also updated the ts_last_edit in the segment table and set it to now() when soft deleting the segment.