A NOR gate outputs 1 only when both inputs are 0. Cross-couple two of them and each output becomes an input of the other. A 1 on one output forces the other to 0, and that 0 is exactly what keeps the first at 1. The loop is self-reinforcing, so it has two stable states and stays in whichever it was last pushed into.
The one forbidden input is S=R=1. Both outputs are pulled to 0, so Q and Q̄ stop being opposites. Worse, if S and R then fall at the same instant, both gates try to rise together and the winner is decided by microscopic differences in the silicon. That is why the JK flip-flop gives that combination a useful meaning instead.
Because it has no clock, an SR latch is level-sensitive: it reacts the moment S or R changes. That makes it ideal for jobs such as switch debouncing, where a single clean transition is needed from a bouncing contact, and it is the first building block of every clocked flip-flop.
NOR latch vs NAND latch
NOR latch (this build): inputs are active HIGH. Idle state is S=R=0, and the forbidden state is S=R=1.
NAND latch: built from a 74HC00, inputs are active LOW. Idle state is S̄=R̄=1, and the forbidden state is S̄=R̄=0.
Both hold a bit in exactly the same way. Only the polarity of the inputs is swapped.