I mean, it's Herodotus. He is famous for starting history as a subject, but his methods were "oh, i heard a tale from a traveller! let's add this to the book, because it's spicy".

So no, I doubt it was that simple as "any woman for any cash just outside the temple".

However, it is probably true some kind of ritual prostitution existed. What form, how often and what percentage of women - is still unknown.

Most probably no, not every women, just a special cohort of "sacred priestesses".

Imagine if nuclear war happened 500 years ago, and you are the Herochodus the self appointed historian, and you meet a guy from the other sea in the west, and he tells you before the collapse in the great city of Veggias there was a cult of Cazin and all women in the city were called hookahs and could fuck you for any money you can give to them, even 1 bottelcap was enough. He is very confident, because it was told to him by his gramps as a secret. Or everyone on west coast just knows it to be true or something.

That is sorta what we are reading here.