The difference is diesel oils have more detergents...not really a bad thing, and can absolutely be used in gas engines. These oils are time proven and made to run some very expensive diesel engines for 1 million plus miles. Also contains more ZDDP than current car oils, which is great for flat tappet motors if you have any. ZDDP is being phased out of gas engine oils because of environmental concerns, and it can slowly plate catalytic converters. 5w-40 is a fine viscosity -- this engine is based on the 4 cyl honda engine which hasn't changed much except for electronics, in decades -- back then 10w-30 was the recommended viscosity. The reason they started the 5w-20 and 0w-20 baloney was to get the C.A.F.E. numbers up for the gubmint...maybe eek out another 0.1 mpg...because the oil is thinner thus lower friction, but in my opinion, lower than optimal viscosity. Honda doesn't care if you only get 200k instead of 300k out of your engine, as long as the govt doesn't penalize them for low MPG. Viscosity index is most important, look at the viscosity index of Rotella T6, probably around 160, vs the VI of other "recommended oils" Rotella T6 will be more viscous at 250deg F than 20w-50 oil, because it has a higher viscosity index --- it does not thin out as much as temperature increases. FYI I use Rotella T6 in pretty much everything, Odyssey, Accord, RX-8, motorcycles, lawnmower.
Edit: just to summarize, I think you are getting a better additive package for your money with T6 or another cj4 oil because commercial operators demand it...with the car oils you get a cheaper additive package and the oil costs more because you are paying for marketing.