Hmm. It's an off-road vehicle, then who's behind you in dense, distracted traffic to need a CHMSL so they don't run into you? That's one. Two, a cargo light projects almost zero light straight back. Most of its light is directed downward toward the truck bed. They don't make suitable CHMSLs no matter what color the lens is painted or what kind of bulb is installed.
They're totally different in terms of number, placement, and type of LEDs, so yeah, they're going to work differently. It can't be predicted how they'll work or if they'll work or how well they're going to work.
That's going to take a different kind of lamp, not just a different kind/color of bulb. Maybe look to adapt a combination CHMSL/cargo light from a '94-up truck, or mount a rooftop LED CHMSL like the one used on the GMC Safari/Chevrolet Astro vans or the Ford Transit Connect vans through 2013.