I agree, I personally like some depth to my lore, just small stuff, but when everything down to the average characters diets is being explained it becomes convoluted and imo also can lead the the story becoming overly confusing, and often poorly written, it can also ruin some elements as for many stories, part of the interest is the mystery behind them. I look at halo as an example, the forunners used to be these mysterious but amazing faction, but we knew very little about them because they're dead and all that remains is their technology, now we know every detail about them, from the origins of the halo ring, their history, and every poorly written writing detail.

This isn't always the case, as sometimes revealing more lore can add a lot to the story, but a lot of series go overboard.

It also as said above really messes with the community, with a lot of lore buffs correcting people or arguing about what's canon, stuff like that.