I think I can supply a bit of context and some suggestions for how to use Stryxhaven.
Firstly:
The trite answer is, this was always marketed as a source book, not an adventure book. But I think what the OP means is "where are the stakes?"
To understand that, I think you need to look at it's literary antecedents.
Clearly, they are not this.
Now, the Harry Potter connection is obvious. But what is a lot less well known is Harry Potter itself draws very heavily on the Mallory Towers novels by Enid Blyton. For those who don't know these are novels aimed at a young female audience - it would be possible get into a very long digression about gender roles in children's literature - about life in a girl's boarding school. It is, basically, a soap opera. The "stakes" are generally about who is friends with who, with characters only occasionally at risk of death, or worse, expulsion. If you are interested in running a low stakes game like this I have a few suggestions: Catch a few episodes of the resent BBC adaptation, rather than wade through Blyton's extremely dated novels. Make sure your players are okay with a low stakes game with the emphasis on role-playing rather than combat (i.e. a Critical Role+ style of play). Encourage your players to start out as rivals, rather than friends. Try to avoid too many "all may family are dead" backstories. Family members are very much alive, and are important NPCs with high (possibly unreasonable) expectations.
"I don't like Mallory Towers, what am I supposed to do with this!"
It does synergise quite well well with WotC's adventure collection books, like Candlekeep, Radiant Citadel and Golden Vault. I would aim for something like The Librarians TV show. A mentor sends the students off on an adventure-of-the-week. Make it very close to a comedy. Clearly, this campaign is not going to be a sandbox.
If you like sandboxes, high stakes and combat, then don't buy this book, it's not aimed at you!