It's all about amp hours and reserve capacity. Mainly reserve capacity as amp hours are often overstated or not listed at all.
The Optima "yellow top" is a dual starting-deep cycle battery and will probably survive more deep discharges than your stock battery, but the biggest ones I can find have a reserve capacity (a factor on how long your radio will run without the engine running) of between 90 and 120 minutes. The stock Motorcraft battery in my Explorer has a RC of 130 minutes. I think a 140 RC battery is optional in the Expedition.
If you commonly run the radio until the truck won't start the Optima may survive more of this abuse, but it's not a true deep cycle like the "Blue Top" versions.
If you really need to run electical accessories with the engine off the same battery system used in many boats is required using an additional deep cycle battery and a switch. Rather a pain on our boats to switch batteries, but leaving the switch in BOTH can kill both batteries and require hand starting the engine. Finding a spot for the second battery can be a challenge.
Not sure how well a pure deep cycle battery will start one of these V8 engines. It may be possible to substitute one for the battery under the hood now. Trojan makes one with a RC of 280 minutes (!) but it's 14x7x11 inches (LWH).
-- Chuck