Ah, Hollow Knight, I have played soooo many hours of this game it's almost ridiculous 😅 It's definitely more gameplay that story driven. Or rather, you show up after the story is pretty much done and you need to dig through the ruins to figure out what the story was. It's very "Dark Souls/Bloodborne" in that way; a lot of vague story which you need to puzzle together for yourself and few definite explanations.

I'm a sucker for that kind of archeological story experience, where I get to sift through the shattered remains of a civilization and figure out how it all went to hell, but it's definitely not a story-focused game, so I think you have the right impression of what you'll get if you keep playing. Hope you find another game you'll have more fun with!