Historically, Plucky Cavalry Charges win battles far more often than the strategic concerns do.And you are unlucky a million times - who wins?
Can't be done in isolation.
For the same money you can build a 500kt BB or a 250kt tender carrying 5 50kt BR.
The latter will beat the former every time one (tender+riders) for one (BB). One BR will struggle against the BB, so 1v1 the BB is superior due to its extensive secondary batteries which can scrub the BR, but that's not a fair fight
5v1 the BR get 5 chances to spinal the BB.
A BatRon of BBs may be eight BBs, I would want at least forty BRs to go up against them.
Those are exceptions not the norm.
War is won by planning and logistics, not one plucky cavalry charge.
Battle is inherently chaotic, and a well timed charge is often decisive. A poorly timed one is often catastrophic.... on the tactical scale. Forces have held against 10x their number with even weapons and good tactics often enough... and sometimes, troops expected to be sacrifices for a strategic goal have held there own in ways that shocked and amazed the strategic command. Even a 10:1 is not a historical guarantee of victory.
Wars are won by winning the battles often enough and well enough to be able to outlast the political will of the opponents. That political will can often be broken by destruction of the means of production and/or causing terror in the populace, or even simply prolonging the conflict past the point where the public supports it...as was seen in the Phillipine Campaign, the Pancho Villa campaign, the World Wars (I & II), Korean War, and Vietnam War. In all of these, the will to fight was broken, and that's what ended the war. Even in Japan - the Emperor realized the US had a weapon his Army, Navy, and Air Force could not fight... and that broke the will to allow further resistance.
Wars are only won when one side or the other decides it's too much to continue - too expensive, too painful, too politically unstable, too dishonorable, or too embarrassing to continue.
Strategy is making certain the war can be continued. Tactics is making certain that more of them die than of you. Winning the war is making certain they don't want to continue, and may or may not involve strategy or simply diplomacy. Or even psychohistorical actions...