[v24.3.x] storage: check for may_have_tombstones in self_compact_segment (manual backport)

[v24.3.x] storage: check for may_have_tombstones in self_compact_segment (manual backport) #49403