Drilling through old, brittle tiles and waterproofing those penetrations is very hard to do.
I prefer to have minimal penetrations on my roof — a few plumbing vent stacks and a couple of ventilator fan outlets — that’s it.
The second worst thing to put in your roof are skylights.
They will ALL eventually leak.
Plus, up north they cause ice damning in the winter.
It is just not a good idea to cut holes in your roof.
Limit the holes in your roof to ridge vent and plumbing stack vent pipes. Even bathroom fans should be vented through a side wall if at all possible.
Ceramics don’t become brittle with age. They are principally an aluminosilicate and are brittle to start with. They can break, but they don’t age.
That’s why archeologists find various ceramic artifacts from 2,000 or 3,000 years ago.
In Florida I put on a roof in 2020 and solar in 2021. Best decision I’ve made in a long time. My electric bill is $33 per month (”fees”) and the 1.5% loan is $155 per. Plus I got reimbursed by the IRS $11,000.
My previous power bill ranged from $200 to $350 a month.