When I went from highway tires (Michelin LT bought at Costco) to AT tires (Nokian nAT) my MPG took a minor hit. Minor, but consistent.
If MPG is important, I would consider a highway tire like the Michelin Defender LTX. They were remarkably good in the snow, too.
Weight, on the highway, doesn’t matter much. Around town it certainly does. On the highway, rolling resistance is king, and the highway tire is the way to go.
@Boodro1 - I don't think it was noted or I missed it. What is the 5% off road that you do (sand/mud/rock crawl/other)? Where do you live and is snow an issue?
Like
@Astro14 before he switched, I have Michelin Defender LTX M/S on my Pilot. I've had previous iterations of the same on multiple SUV's. They take me on the beach, state forest roads, gravel/rocks/light mud to hunting cabin. They have not let me down at any time. Mine will age out before wear out but might be same that goes on. Do they have that rough, tough off-road look, nope. But for me they work great in the daily drive, towing small trailer, quiet, good wet and dry. I can't say about snow as I run full winter.
You are focusing on rolling resistance for MPG. The more highway versions would be a better choice.
What parts are you looking to improve on, besides noise from the Pirelli? Tires are not an inexpensive investment but unless you really hate them, probably won't switch until worn out.
My 81yo father-in-law "needs to have" that look at me, I'm macho off road look. Reality he needs a Defender LTX M/S but wouldn't be happy with the look. The most off road he does is when he misses my driveway and ends up on part of the lawn or drives over a curb because he missed a driveway apron somewhere. I do think the Cooper looks great for that and bonus that they are quiet. The previous Falken Wildpeak AT Trail was also good for looks, it stayed quiet the whole time. It lasted about 30k of around town driving but so did the Pirelli Scorpion AT and OEM Falken Wildpeak HT01.
Focus on the needs of your daily use with priority, factor in some off road traction for what you actually do. In my opinion, rolling resistance when on a Ford F150 used for daily commuting should be way down if not off the list.
For me daily drive on 5-7 vehicles priorities - wet, dry, noise, use scenario, treadlife/cost, fitting appearance for vehicle. I don't think in 40+ years I ever worried about the LRR. If they happened to work out that way, great. I bought a naturally aspirated V6, I muzzled the cylinder deactivation, I want it running on 6, not concerned with the possible slight MPG increase running on 3. If I'm that concerned on the rolling resistance than I need a different vehicle (like the old school Honda insight I saw today driving home). Of course YMMV.