Honey is generally considered safe to eat during pregnancy. The well-known warning about honey and botulism applies to babies under 12 months, not to pregnant adults. Health authorities including the NHS and CDC do not advise pregnant people to avoid honey.
Honey is a natural sweetener made by bees. It sometimes contains dormant spores of a bacterium called Clostridium botulinum. These spores are the reason honey is not given to infants under 1 year old, whose immature gut cannot handle them. Both raw (unpasteurized) and processed honey can contain these spores.
A healthy adult's digestive system and gut bacteria neutralize botulism spores before they can cause harm, which is why the CDC and NHS restrict the infant-botulism warning to babies under 12 months. There is no evidence that eating honey harms a pregnant person or their baby. The botulism risk that makes honey unsafe for infants does not apply to you during pregnancy.
Honey is high in sugar, so keep an eye on portions, especially if you are managing gestational diabetes or blood sugar — a point worth raising with your provider. It is not a treatment for coughs or sore throats in place of medical care. If you have a compromised immune system, it is reasonable to ask your provider whether pasteurized honey is the safer choice for you.