[Backport 2.17] Integrate translog cleanup with snapshot deletion and fix primary term deletion logic

[Backport 2.17] Integrate translog cleanup with snapshot deletion and fix primary term deletion logic #40167