I'm pretty lucky to have one main local store, a fairly local GW store, and 2 or 3 local hobby stores I don't really frequent as much. They tend to be mostly cards with just a small group of tabletop players, but my main one is much more diverse.
Not counting the GW store, because your not actually allowed to play there much anymore, but in the other 3 its all broadly similar. Both Age of Sigmar and 40k are going strong. There's dedicated leagues, both narrative and competitive, for both. At my main store the 40k league is consistently around 60 players, and the AoS around 40ish. It depends a lot on schedule cause most of the players are into other games to. The Game of Thrones tabletop war game is picking up a fair bit of steam, D&D's always around, but I feel like Warmachine and the other wargames have fallen a little bit.
Fantasy never really went away, but did get much smaller. When I talked to the store owner back on the 6th during preorder day we were shooting the breeze about numbers. He figures there's 5-10 games of Fantasy played each week for the last few years. Mostly 8th edition, but followed up by a good number of 6th and 3rd edition respectively, with a scattering of other stuff. We're all curious to see how that changes with old world release, but there's been a bit of uh, drama in that regard recently that might make things stay a bit quiet.
I'm very involved in the narrative scene with the local store. Often serving as one of the main campaign writers and I run a lot of the tutorials or getting started stuff for new players. We're planning to wait till the spring or possibly summer, and then run a fun, easy mode Border Princes style campaign for Fantasy players using the new rules. There's a fair bit of interest, and as the hot new thing we're pretty confident a lot of the other players will take a break from their usual stuff to give it a go.