The one thing you can do to make a TIFF smaller from Lightroom Classic is to apply compression. Lightroom Classic offers a ZIP compression option for TIFF. But to retain the quality and flexibility of the original, even compressed TIFF cannot be as small as JPEG or raw format. (The only other ways to reduce TIFF size are to reduce bit depth and reduce pixel dimensions.)
It’s common to think of the original photo file (raw or JPEG) as the reference for how big a photo file should be. But in fact, TIFF is closer to the natural size of an image, and raw and JPEG are actually the unusual file sizes. Camera raw is not a universally supported format for editing, printing, website posting, etc. Only a very small number of applications such as Lightroom Classic can work with raw without first converting them expanded to a full RGB file. To be more widely compatible with common applications and services, an image must be converted to TIFF or Photoshop format (full quality, large file) or JPEG (compromised quality, very small file).
Here's an example. Somebody brings home a box containing a flat-packed wardrobe so they can store clothes in it, and they assemble that furniture. Assembled and ready for use, it now takes up maybe 10 times the 3D space of the box it came in. You could say, now wait a minute, the size of that furniture bloated up 10x, this is wrong, what’s the deal? But we don’t look at it that way. We understand that for the wardrobe to actually do what it’s supposed to do and store clothes, it has to be expanded to its natural size. We could ask for the wardrobe to be recompressed down to its “original” compact size that fits in the flat box it came in, but that compact size would make it completely unable to store clothes, and therefore unusable as furniture. To be usable, that furniture must be fully expanded.
The same is true of images. If you want a raw image to be usable in most image applications, or display it on a website, it cannot remain raw. It has to be converted to an expanded channel format, such as TIFF or Photoshop format. But files in those formats cannot be as small as the original raw. Now, another widely compatible RGB channel format is JPEG, which can be as small as a raw (or smaller) and is needed to display on a website; but there is no free lunch there either, because to get the file size down that small, JPEG throws out a lot of the image’s original editing flexibility .