I know that I'm in the minority here, but I'm in no hurry to hear about the 2026 books. There are two starter sets coming out soon, then two FR books and then the Eberron book. Dragon Delves is still recent. I'll think about future releases later on....
As a fan, I can't seem to wait, but a FLGS retailer, I'm 110% with you. It's a real problem these days, that we're always talking about two, three books down the line, and rarely as much about the one coming up SOON. I honestly think that the comic book industry, bad as it's always been run, had this thing right back when I first started with it, 30+ years ago (it had and has other issues instead).
To whit: The ideal, IMO is to announce a product not more than TWO MONTHS before it releases. You spend 1 month collecting orders, order it, and it arrives 1 month later. Maybe MAYBE you could extend that to three months, if a 1-month lead-time is not good enough for printing these days.
But more than that? I think it's actually bad. Hype occurs too soon, and by the time something is out, you're hyped for something further down the line. Often that further-hype will make you pass on the thing that excited you so much 6-8 months ago when it was all the rage in the announcements.
I think this is one of the things that kills the "Box Office" these days, as well. Announcements are just too darn early.