So I don’t understand intuitively what the scattering cross section is.
Intuitively, the cross section is just that--it is the cross-sectional area of the object that is scattering the probe particles in the beam. I will call the object that is scattering the probe particles the "scatterer."
We are only interested in a cross-sectional area since the dimension along the beam of probe particles does not matter. (Or rather, the beam just "sees" the cross sectional area, not the volume.)
If we are probing a fixed scatterer, the cross section should be the same whether we are scattering x-rays or electrons or alpha particles, or whatever. (This is not entirely true, because some particles might not interact at all, e.g., if the scatterer is scattering via electromagnetic forces, then neutral particles can't "see" it.) (And, of course, the full description of scattering will account for probe differences, but the properties of the scatterer will remain the same.)
Consider the example of a hard sphere of radius $R$. If we shoot a beam of particles at the hard sphere then particles that are within $R$ of the center of the sphere will scatter and particles that are outside of $R$ will not. Therefore the total scattering cross section of the hard sphere is $\pi R^2$. In other words, we know that when we integrate $\int d\Omega \frac{d\sigma}{d\Omega}$ we better end up with $\pi R^2$. We just have to arrive at this result in a funny way because we are trying to back out a result regarding the scatterer based only on a measurement of the scattered probe particles.
Another way to this about this is that we are trying to figure out the "shape" of the scatterer, but we only have information about the scattered probe particles. (We can't "see" the scatterer directly, we can only measure the scattered probe particles.)
Suppose we are scattering off of a cube with sides of length $L$. If the beam is oriented directly along one of the cube edge directions the cross section will be $L^2$. (Of course, in real life it is hard to perfectly align a scatterer with the beam, so in real life will will likely have to average over all the cube's orientations).
Suppose we are scattering off of a Coulomb potential. Of course, this will only scatter charged particles, but it will scatter any charged particles regardless of how big their impact parameter is (assuming it is a completely unscreened Coulomb potential). Therefore the scattering cross section is infinite in this case.
Why is it useful?
Because we usually can not just go a "look" at the scatterer. The scatterer is usually something like a molecule, or a collection of atoms in a solid, which is/are invisible to the naked eye.
The only way we can "see" these things is by shooting in a beam of probe particles and looking at the angular distribution of scattered particles.
We have to back out information about the "shape" (or other properties) of the scatterer using only the information obtained from the scattered probe particles.
Image you are asked to figure out the shape of an object, but you can't look at it. Image that the only thing you can do is to close your eyes and throw ping-pong balls at it. You throw lots of ping-pong balls at the object and some of them bounce directly back at your face, some of them make glancing blows and bounce off part of the walls, and some pass by untouched. You can glean info about the shape of the unseen object by carefully recording which ping-pong balls bounce off which ways for which impact parameters. If you throw billions of ping-pong balls you can map out the shape (or rather the cross-sectional shape) of the unseen object.
Scattering is one of our only tools by which we can study small objects like atoms, molecules, and so on.