Aided by producer wunderkind Andrew Watt, McCartney delivers some of his most personal and introspective songwriting in years, and makes amends for a few recent misfires