To your point, the Lower Decks writers were clearly TNG fans.
Wil Wheaton in Ready Room has some episodes about Lower Decks. The Crossover episode https://youtu.be/3SiYyIAz5xU and the final recap https://youtu.be/NK94dXm2Wis
I'd also generally suggest Dropping Names with Brent and Jonny ( https://www.youtube.com/@Dropping-Names ) where Brent Spinner and Johnathan Frakes chat with people about movies and TV. While it's not about Trek, it's a frequent tangential topic. I believe it's helpful in the context of "how much the fandom extends to other people in the entertainment industry."