Keep orphan-cleanup snapshot active on PG18

[ihalatci]

PG18 regress, failure, and isolation jobs assert because CleanupRecordExists() uses GetLatestSnapshot() without registering or activating it.

Keep the fresh-snapshot semantics, push/pop it around the catalog scan, and validate the affected PG18 cassert suites.