Similar to trilogies and series like Harry Potter, Dune, Game of Thrones are out there and people love, do you know any book series in the non fiction realm that is really good?
I suspect this isn't exactly what you're after, but I'm nonetheless tempted to suggest the Dictionary of Japanese Grammar trilogy. (A Dictionary of Basic Japanese Grammar, A Dictionary of Intermediate Japanese Grammar, A Dictionary of Advanced Japanese Grammar, by Seiichi Makino and Michio Tsutsui.) They are, as far as I know, pretty much the definitive grammar-reference-books for English-speakers looking to understand the Japanese language, with an impressive mix of thoroughness and comprehensibility; the first book alone has far more grammar than the typical early-stage language-learner is likely to need for years, and the next two are each comparably dense.
A few favourite non-fiction book pairs (duologies?):
Sapiens by Yuval Noah Harari (human history)
Homo Deus by Yuval Noah Harari (transhumanist futurology)
Our Mathematical Universe by Max Tegmark (physics and astronomy)
Life 3.0 by Max Tegmark (transhumanist futurology)
A Number For Your Thoughts by Malcom E Lines (mathematics)
Think of a Number by Malcom E Lines (mathematics)