It worked fine for me in editor: boots playing horizon vanguard - YouTube
I added a SceneCapture2D component to my pawn, I set the target of that to a new RenderTarget texture, and I used the Blueprint nodes in the documentation to set the Spectator Screen Mode to Texture and to set the Spectator Screen Texture to the RenderTarget. And I did some other stuff to animate the capture component a bit.