Did a remorseful Randy Herman Jr. really commit a brutal murder in his sleep, or was it a convenient cover story? The Sky Original film explores this shocking case