As you can export the TIFF file uncorrupted, you may want try to export it with "File Export > Export unmodified Original.
Then try to convert the file to a different format using Preview or another photo editor. If that succeeds, import the converted file to Photos and delete the previous corrupted version.
Just a hunch, but some of my TIFF files that no longer could be edited in Photos have been using an old color sync profile, that no longer has been supported by the system. The Preview.app can be used to change th color sync profile. In Preview on macOS 26 Tahoe the command to modify the color sync profile *** be found at the bottom of the "Tools" menu, when you are viewing an image file in Preview.
You wrote "large TIFFs". Sometimes the problem is just the file size or the resolution. The Photos.app does not handle very large image files gracefully, if the Mac does not have much much memory. Then it can help to close all other apps and restart the Mac to free as much memory as possible, before trying to work with this file. I am not keeping my very large TIFFs in Photos, but smaller, downsized versions. I am having some very large TIFFS, with a size of more than 1GB - satellite images. I can view them in PhotoSHop, but not in Photos. These files I am keeping in folders in the Finder, and have in Photos just seller copies.