Our house has an asbestos flue in the bathroom. I'm very careful never to go near that thing, and never ever to cut/drill/attempt to remove it myself. But I wonder how many people would never know it was asbestos.
If you leave asbestos alone it's safe, and if you need to drill into it, use shaving cream so that the fibers don't get into the air. It's not a big deal if you are careful. But don't be reckless - you need to know what you are drilling into and do it slowly.
The cancer causing mechanism of asbestos is mechanical. A single strand in the wrong place could cut your DNA up. With any probabilistic process the more exposure the more chances and the greater the likelihood.