As much as I like SH-formats and the idea of this as a topic for a doomsday scenario, this doesn't feel like it really plays to that format's strengths.
Where many of the Serpent's Hand articles shine is how they use the conceit of documentation from magical or multiverse beings to really go all-out with flowery descriptions and flavorful world building - the realm of fantasy being a nice reprieve from the more detached Foundation tone, here though, the treatment is dry to where it feels like reading a book report. It doesn't seem like the content would change so drastically if it were rewritten to be an SCP article.
I genuinely can't tell how I'm supposed to feel about the piece, or what the point of it is from an in-universe perspective. Clear (watsonian) authorial intent isn't always a super-important inclusion in this format, but is something that can be utilized to effect. For instance: How To Adopt A Butterfly Koi and A Love Letter to a Lady Mantis drip with adoration of their subjects, The Second Child and Summer's Exile treat their subjects as significant and worthy of respect, and The Conspiracy of Sigma 3 is purely sensationalist. This goes without mentioning articles where the authors themselves are something of note, such as in The Choir Below and Koi Format, both of which help establish just how broad SH membership really is.
Too much of this is so plainly stated, it doesn't come close to realizing its potential.
As an aside "The Slumbering Prince He Who Sleeps, The Waking Lord," is all very well and good and a decent way to set up the expectation for a mythical subject of great power, but "scary dream boss" immediately takes the piss out of it.