Some herbal preparations can be made without alcohol, but not all. 

You might find this article on our website helpful:
https://theherbalacademy.com/art-of-the-alcohol-free-apothecary/

We would encourage you to focus on the wonderful preparations that you can make alcohol free, such as glycerites, oxymels, herbal honey, herbal infusions/decoctions, and more (as mentioned in the article above). There are still so many great recipes to craft and explore!

While there is not always a straight substitute for alcohol in tinctures (although many times you can create one with glycerin instead), in some comes instances you can use the same herbs for tincture recipes to create an oxymel or syrup instead.

Here are a few links that may be helpful:
https://theherbalacademy.com/herbal-syrup/
https://theherbalacademy.com/how-to-make-an-oxymel/