Space is so big and empty that even for something like the asteroid belt you could pass through any point randomly and on average be thousands of kilometers from the nearest rock. Perhaps even tens of thousands.
https://physics.stackexchange.com/questions/26712/what-is-th...
Space is BIG.
It's extremely unlikely to get close to any object while randomly passing through its orbit.
Unfortunately, space becomes a lot smaller once you want to park yourself in a similar orbit to another object. Don't get me wrong, it's still massive, but since orbits trace out a path the problem becomes figuring out if two paths intercept rather than if two points intercept.
This is why access to 'space' will not really be impacted in the case of a Kessler cascade; you can go through low earth orbits on the way to somewhere else, but if you tried to stay in low earth orbit you'd almost certainly be hit by something.
Whiile the earth is obviously much bigger than a space craft, you would think should there be a bunch of craft flying around in the future, theres a fair odds of it happening every few years.
Also for example, the ISS has already been hit a couple of times: https://www.iflscience.com/space/an-astronaut-used-his-finge...
If we have thousands or 10's of thousands of craft in space in the future I would suspect this will be a very real issue on a semi regular basis.
Take what I say with a healthy dose of skeptism as not an expert or even well researched, but logically on above seems quite a reasonable risk.
More likely, the small rock would put a hole into the spaceship. This isn't a disaster. The spaceship residents would notice a gradually decreasing amount of pressure, assess where the leak is, and put a piece of duct tape over the hole.
Remember kids, real life isn't like the movies.
In the same way that an object won't explode when hit by a subsonic 9mm round with ~0.5kJ of muzzle energy ('just' causing a leak and decreasing amount of blood pressure) it will when hit by a 0.50 calibre round with 14-20kJ of muzzle energy.
For two objects in low earth orbit, travelling in opposite directions, the speed of impact can be over 14km/s - or 98000kJ per kg. At that speed even a relatively small object is going to cause a massive explosion when it hits you.
Since a solar sail is just a huge sheet of plastic coated in aluminum, any impact with the sail will tend to leave just a pinhole, or possibly a tear. You do need to design your sail with ripstops, but the total area lost to the pinholes will tend to be quite small.