Nathan, you left out a key word in the wiki description of the .41AE. It was designed to duplicate the performance of the .41 Magnum police cartridge. That was a downloaded, Special equivalent loading, very similar to .38-40 or .40S&W. Not remotely like 170@1800.
Also, the .41AE was designed to work in 9mm type guns. I believe it headspaces 9mm, with the intent being to allow barrel and caliber changes from the same gun.
The .40S&W pretty much made the .41AE unnecessary.
With regard to the .40 revolver, in N frames the 610 allows more versatility. I don't see a CCW .40 getting any smaller than an L frame, so I don't see a point to it, myself.