The purpose of the alternator isn't to run the vehicle loads. The purpose of the alternator is to keep the battery charged. The battery has the reserve capacity to handle a large amount of loads starting at once or turning on and off multiple times. We keep getting larger batteries or more powerful batteries because we load the vehicles with more and more electrical loads.
Yes, the purpose of the alternator is to run the vehicle loads
and charge the battery. You can't separate those two functions. The battery and alternator both supply vehicle loads.
Larger batteries are only a benefit if you're going to be using a lot more battery power versus time than the alternator can recharge, which either means that you're using devices with the engine off, or you've failed to properly size your alternator so you're running in constant depletion mode . Thats what reserve capacity is.
Otherwise people get a bigger battery because it has more parallel internal plate area, which lowers the internal resistance. That's where higher CCA rating comes from for a given type of battery (make it bigger, more CCA). That lower internal resistance is what helps with big electrical loads turning on and off, not the reserve capacity. For example a big deep cycle battery will have big reserve capacity, but relatively poor internal resistance, which makes it a bad choice for big transient loads because of voltage drop.
So yes, with a properly sized alternator, you could downsize the battery. But you're decreasing your safety margin for certain conditions, and you may see higher voltage drop with a smaller battery under certain conditions (maybe running a winch for example).
If you want to throw money at it, a racing battery that has low internal resistance can supply big cranking amps in a very small package, but will have small reserve capacity. You could also run two 6V Optima batteries in series, and put the batteries in different locations (does Optima still make those 6volt batteries?).