[2019] Why did the revive hive not get me back to my feet in this scenario?

Without seeing the Reviver Hive it's difficult to tell. As someone else suggested, it might've been destroyed by a NPC.