Github comment for context: https://github.com/wiredtiger/wiredtiger/pull/11272#discussion_r1862742104

This ticket is to review what flags should be set when live restore opens a backing file or creates a tombstone. This should reviewed for all cases where live_restore_fs.c calls fs_open_file