If you are going the Ktuner route, you need to speak with one of the dealers & tuners on those specifics regarding the G1 Ridgeline.
As far as swapping an engine....... Since the folks who swapped the motor into the Ridgeline are not active here, I would recommend that either you do full research by comparing engines on your own, looking at facebook groups, or speaking with a engine builder familiar with the J-series. To make things easy and straight forward, sticking with a Z4 block would be best.
There are guys on Facebook discussing a 'stroker' kits using a J37A1 crank and rods, with J35A8 pistons ('08 TL-S piston with 11.0 to 1 compression). Your stock Z4 has 10.5:1 compression. Do know the Acura recommends premium fuel, along with a different engine management parameters.
The point is, it can get a little too complicated between sensors, VCM, emission control systems, etc etc when switching to a different engine. Since none of the J37 blocks are VCM equipped, I am not sure how the oiling and pistons would cope when mated to your Pilot and the VCM decides to kick in. However, you can swap an engine, get the electronics sorted out and use a VCM defeat device to prevent the engine from going into VCM mode. I do not recommend this as some of those who have done this have seen emission related issues, while others have not. Additionally, I am not comfortable with such a defeat device and its implications, thus I do not advocate it.