Error encountered while reading TIFF image
Adobe Indesign 2023 (v18).
When render TIFF images from Blender using the Deflate (ZIP) option.
All other compression options gives images with black background and no transparency.
Up to v17 Indesign 2022 these images imported just fine.
When doing a resave in Photoshop with no changes, the images imports fine.
Fix for this issue is now available in the latest release of InDesign 2023 - that is, InDesign 18.1 version.
Please update to this version of InDesign to get the fix.
Adobe InDesign team