Is adherence to Catholic belief and practice really just a matter of intelligence and catechesis?

I don't think so.  

Will letting women be priests, and 86ing the rules on divorce and other matters relating to sex make any difference in church attendance?

I don't think so.  I don't think it would make any difference whatsoever.