Concur with BR although with BRP and L-M 5W40 I observed (via dashboard pressure gauge) the "knee" at 3K miles. Whereupon I changed oil.
The viscosity issue, at least for me, is not engine oil pressure (which is allowed to drop to 8.7psi at idle) but rather the HCM solenoids and multiplate pressure-engaged clutch. The HCM has its own oil pumps (scavenge, pressure) with two pressure circuits and the line pressure circuit operates at twice the maximum engine oil pressure. Although I'm sure the TCM has long-term trim to compensate for solenoid and clutch plate wear, my experience is my 95K miles transmission operates more smoothly and consistently with higher viscosity oil (in my case 15W-50).
I have the parts to tap into the HCM oil pressure sensor (it's a standard 3-wire 5V transducer) but have been procrastinating.