There's a difference between a tranny flush and a trans fluid change. The flush uses a machine to virtually replace all of the fluid in your transmission. This could be dangerous for your transmission if done incorrectly or with improper equipment. A fluid change you might as well do yourself. You won't remove all of the fluid, but it'll still help.
I've never owned a Honda, but I know that some manufacturers recommend a tranny flush at as few as 40,000km, and others recommend it as high as 150,000km or sooner as needed (judging from the appearance and smell of your tranny fluid). Tranny flushes usually cost between $180 and $250 depending on where you go. If it's significantly less than that, it's probably just a fluid change.
There are many conflicting views out there. Some say that if you haven't flushed your tranny in 100,000km, you're better off not doing it now and you should just cross your fingers and hope for the best. Others say that's complete bullshit. Still others believe you should just change your fluid regularly rather than opt for a complete flush. I'd recommend discussing it with your dealership or someone in the know.