it would have been better and more realistic imo if we saw a slow and steady transformation rather than one hype moment in the final arc or so.
Maybe it started now in Final Saga
We also don't get much regarding Nami's World Map or Chopper's Studies or Robin's Research or any Info on All Blue or barely anything from Mihawk ... etc So it's not just Usopp, Everyone Dreams are reserved for now
But now that Egghead Started, look what happened, Usopp is reuniting with Dorry/Brogy & closer than ever to Elbaf, Robin learned that Saul is Alive & Ohara Books are in Elbaf, Egghead is full of Science & Transportation stuff for Franky to learn from, We are slowly getting more info on Mihawk, Fishmen Discrimination that started 200 Years ago is mentioned which is important obviously for Jinbe's Dream to Stop Racism ... etc
And i'm sure We will get more Info on All Blue, Chopper's Cure & Brook's Backstory ... etc
Usopp just gets shit on cuz his Dream relies on his Usefulness unlike others who can still be useful without their Dreams being present in current Plot, so it's more noticeable & more annoying, but in general, all SH's Dreams were Sidelined & it's clear that They were reserved for Final Saga, Egghead restarted those Sub-Plots & it's gonna be a slow & steady transformation from now on
So it's not just One Hype Moment, it's One Hype Arc focusing on Straw Hats Dreams for let's say almost 100 Chapters or whatever OP gonna lst for after Egghead Ends