Put a book on a table. Gravity pulls it down with, say, 10 N, yet it does not fall. The tabletop squashes very slightly, like an extremely stiff mattress, and pushes back up. Load it more and it squashes more and pushes harder. Press down on the book with your hand with another 5 N and the table pushes up with 15 N. The normal force adjusts to whatever is needed to stop the book going into the surface.
'Normal' means perpendicular. The push from a surface always points straight out of it, at right angles. On a ramp tilted at 30°, the normal force on a box points out of the ramp, tilted 30° from vertical, and it balances only the part of the weight that presses into the ramp: N=mgcos30∘≈0.87mg. The rest of the weight, along the slope, is what makes the box slide. A wall pushes horizontally on a ladder leaning against it, because the wall's surface is vertical.
The normal force is not the object's weight, even when the two are equal. Weight is Earth pulling on the book; the normal force is the table pushing on the book. They match only on a level surface, with nothing else pushing up or down and no vertical acceleration. In a lift accelerating upward at 1.5 m/s², a 70 kg person's weight is still 686 N, but the floor pushes up with 791 N. And the two are not a third-law pair: the partner of the table's push on the book is the book's push on the table.
Think of it like this. A surface behaves like a very stiff trampoline: it dents a tiny amount under a load and pushes back straight out of its face, harder the more it is pressed. That is why the push is always perpendicular to the surface and grows when you press down. The difference is that a table's dent is far too small to see.
Core idea. A surface pushes perpendicular to itself with whatever force stops an object from moving into it. You find that force by balancing the forces perpendicular to the surface, so it equals mg only in the simplest case.