I think that description is a little exaggerated -- it doesn't smell amazing, but it doesn't really smell like dung either. Most Indian/Indian subcontinent grocers should have powdered asafoetida for sale; you can see/smell for yourself!

It tastes very good with any kind of dal (split beans, lentils, etc).