Goddesses are used for enhancement. If you use the correct goddess(Anu for Melee, Danu for Missile, Tartu for Magic) to enhance a unit, the unit will gain 3 levels (upto its max). This is particularly usefull on cards over level 100 where it takes a lot of feeders to get the same effect.