Walls have a tiny amount of radioactive material, but they protect you from the radiation of the exterior. I don't know if the walls increase or decrease your cancer risk.
There are many thinks that may cause cancer. It's important to calculate the risk of each one, because you can't avoid all of them.
The radioactivity in a smoke alarm is already negligible when you hold it in your hand, never mind when it's mounted on a ceiling.
Additionally the americium-241 used in smoke detectors is mainly alpha decay and a sheet of paper will stop it, the remaining radiation that is dangerous is gamma and it's exposure is so far below annual average background that you might not even bother. Flying in a plane will expose you to a thousand times more radiation.
The difference between asbestos and radiation is that there is no "safe" amount of asbestos exposure, according to OSHA.
Your own source material shows just living near asbestos gives you higher risk of cancer. You're trying to argue that we aren't at significant risk without prolonged exposure. Living with asbestos is prolonged exposure. Increasing the amount used in products that we all live around/near will increase the risk and incidence of cancers.