ATF is basically a hydraulic oil/lube.
Manual trans fluid is specifically made so it plays nice with things normally found in manual transmissions such as brass, bronze, synchros, etc.
You will find gear oil and manual trans lubes listed as GL4 and/or GL5.
The GL differential lube rating system has NOTHING to do with manual transmissions... it's specifically about how much wear happens in a hypoid differential.
There is no SAE spec/standard for manual transmissions.
Knowing the above you may think that GL5 is better than GL4... for differentials yes.
The difference is GL5 gear lubes have EP (extreme pressure) additives, USUALLY some amount of sulfur.. which provides additional protection in sliding gears (hypoid).
The problem is these additives attach themselves to yellow metals (bronze or brass, usually used in manual transmission synchros).. and causes them to basically wipe themselves out.
Because of how the 4/5 rating system is... anything that is GL5 rated... will mean it passes GL4 standards. So you'll find some gear lubes with GL4 + GL5 on them. Don't use GL5 in a manual trans to err on the side of safety. There are some that are safe, but short of calling the manufacturer (and even then who knows if you're being given the right info or not), you won't know.
Also note that the gear oil GL-x and the motor oil SM/SN/SL/etc weight ratings are on two completely different scales.
75w90 is equivalent to 10w40. Look at the SAE charts on this page for comparison:
https://wiki.anton-paar.com/en/sae-viscosity-grades/
Motor oils are meant for shorter change intervals and will likely lose their viscosity sooner than a gear oil.
Fun fact: The NV3500 manual trans in 03-06 Wranglers calls for Mopar NV3500 Manual Trans Fluid (doesn't have a viscosity or anything... it's just special fluid for that trans)... the part number that it superceded? Mopar 10w30 synthetic motor oil.
I haven't done enough research on ATF to know the specific differences... but I'd wager to guess that running a thin manual trans lube such as Redline MTL would be an improvement.
FWIW per this:
https://www.fcsdchemicalsandlubricants.com/main/additionalinfo/Product%20Data%20Sheet%20MERCON%20V.pdf
Mercon V is 7.5cSt at 100C... between a 20w and 25w oil. (note that mm squared per second IS centistokes... it's a direct conversion).
Redline MTL is about 10cSt FWIW... so it's a good difference in weight... but if some use it with success then go for it.
To muddy things up even more my car (Mazda2) specifies 75w80 in the US, but 75w85 and 75w90 in other parts of the world. My car shifts smoother/better with the Ford XTM5QS MTF (75w90) than with Redline MTL (75w80).
And to do so even more... chances are low your trans will ever reach 212F... so since fluids are not tested at any viscosities between stupidly cold and 100C... you'll never know which ones are REALLY thinner/thicker at operating temp. You can make some decent guesses, but that's about it.
I'd highly consider trying just 10W30 oil and see how it feels... it's at least inexpensive and easy to find if it does anything funny. Reality is it's a truck transmission... it's unlikely to care as long as something is in it.