From my brief research, a true ceramic coating may last years longer than a traditional wax but it’s a time consuming and expensive process which has to be done by a Pro because it bonds to the paint so any flaws would have to be wet sanded out. For myself, even the possibility of wet sanding the clearcoat makes it a non-starter.
As far as the DIY products available, I suspect that the formulation is significantly different from the Pro stuff, which is why the DIY Ceramic only lasts a couple of months longer than the traditional wax products. i.e. The “Ceramic” on the lable is more of a marketing tool that any significant durability improvement.
But generally, my view of waxes is that they’re primarily a “sacrificial coating”,
something you apply to protect the paint from chemicals, UV and dust scratches. When the wax wears out in 6-12 months you just remove it with a wash of dishwashing liquid, apply a new clean coat of wax and those modern spray waxes do the job so well and make it so easy.
.
.