Tears of the Kingdom is very much a sequel, so I dunno if I can recommend it as your first Zelda game from a lore perspective, but that said, I am a firm believer that the best game for anyone to start with in any series is whichever one grasps your interest first. There might be games that are objectively better introductions to the series than Tears, but if this is the first one to pique your interest when the others never did I don't think that's something to be ignored. My two cents.
If you want to know which one I think gives the best introduction to the series, I'd say any of Ocarina of Time, A Link to the Past, Wind Waker, Twilight Princess, or Breath of the Wild are great choices.
My personal favourite Zelda game is Majora's Mask, but like Tears, it suffers from too much of being a sequel to Ocarina of Time for it to be a person's ideal "first game," and it also is a big enough departure from others in the series in terms of its gameplay to make it a poor introduction for the rest of the series in general.
Welcome to ZD!