The Boys showrunner says Vought Rising spin-off is “really graphic, really profane” and is “a lurid, pulpy detective story”