Rosin has a complex molecular structure that is too big to cross the blood-brain barrier.
It is a lung irritant and has an associated lung disease risk of the form of adult-onset asthma but it cannot cause brain cancer; there is no known link between rosin and any form lung cancer.
Most of us don't use rosin anymore, as it's an absolutely awful flux, synthetic fluxes are more effective and don't have the same risks - although it's probably too early to say on carcinogenic risks, but needless to say with many of us gen Xers having spent our lives using synthetic flux, we'd have expected to see cancer clusters by now.
You will definitely be getting lead dust on your hands when working with lead solder though. Hopefully most people are smart enough to wash their hands after soldering, regardless of lead content, but I wouldn't be surprised if a lot of hobbyists were eating lead without noticing.
I would more naturally link rosin to respiratory system cancers, for example.
Soldering hazards, especially if we're speaking about cancers, is mainly related to rosin yes.
Now you're willing to switch the discussion to IQ drop? From cancer?
Lead on the other hand vaporizes well above soldering temperatures... Can / does rosin vapor can carry lead?