Dwarves have no bedrooms, and only 8 beds for 24 dwarves in an open area that is also your trade depot and your dining room (only three tables) and no traps or even doors to keep anything out, with no military either. (Oh boy if sieges and ambushes still existed, would THIS fort be Fun...)
You have no bookkeeper, so I can't trace the stocks. (No, wait, there is a bookkeeper, but there hasn't been any room or desk assigned, so no work is being done...)
Meanwhile, instead of doing anything vital to your survival, you're excavating the entire mountain to produce a hundred times more ore than you can actually use. You don't even appear to have a smelter.
You DO, however, have time to make a craftdwarf workshop that only makes things from horn or making bone crafts.
In general, you have hauleritis. Common among new players. You're playing around with unnecessary things "because you want your dwarves to be busy" instead of assigning them more useful jobs. This is creating a logistical nightmare, and leaving your fortress utterly exposed and undefended.
Anyway, going to the relatively more immediate problem, as soon as I punched in a new order to brew from fruit, it immediately did so. Then it declared in an announcement that it could not produce drink. I'm not sure why, you have 15 barrels looking at the furniture stockpile (no stocks menu, so I can't be sure, but nothing seems to be in the carpentery workshops) and there are cranberries and such sitting in barrels.
I'm going to guess this is one of those bugs with DFHack and workflow, where I've heard that if you have too much crap lying around, it will cause hiccups where jobs are ignored.
I'd suggest not using the repeat button, and either using the manager, or else using the more advanced workflow features that let you set it to "make more booze when below 100".