I think it is reasonable to expect that any trader who chooses to trade in Yembo in Open mode ought to be aware of the risks they face (if they don't, they'll find out pretty quickly when they visit it for the first time). Traders have the option of contributing to the community goal in Solo if they so wish, and there's nothing wrong with that: if you enjoy the challenge of trading with just NPCs for company, that's totally fine. It is also quite a big galaxy, and there are loads of profitable routes where you hardly ever encounter another player, and that's another valid choice.
Community goals encourage players to visit a particular location; I'm pretty sure that at least part of the idea is to increase the opportunity for PVP interaction. Interaction of all types: good and bad.
Personally, I find interaction with other players is by far the most rewarding aspect of the game, and the risk of being interdicted by a pirate gunship, or even a homicidal maniac, is what gets my pulse racing. That's why I go to Yembo - its by far the best fun you can have as a trader. As with all game mechanics, there needs to be balance - I need a chance of escaping, and the pirate needs to be able to get a reasonable return on their chosen career.
And a sensible trader will balance risk. They know there's a chance of being interdicted; they won't risk more than they can afford to lose, and they will be willing to negotiate. Even a Type 6 is an expensive ship: I will do whatever I can to avoid losing it, and dropping cargo is a perfectly reasonable outcome if it saves me from huge repair bills or even ship loss.
Properly-prepared pirates have the upper hand in interdictions: they have chosen the target, they have chosen to start the negotiation. And if they are properly prepared, the pirate will make the trader believe that dropping cargo is the best outcome.
I'll do everything I can to avoid being interdicted, but a player lying a reasonably nimble gunship won't have too much trouble bringing me to a halt. So I need to decide how best to protect myself. Fighting isn't an option, so I have a choice of negotiating or running away. And the pirate can help me make that decision.
A plea to pirates: decise what your demands are going to be, and set up some macros to message your target to make your intentions clear. If I get a message along the lines of "I have a very large gunship, and if you try to escape you will die horribly in the emptiness of space. Please wait while I scan your cargo and I will then make my demands", then I know that in all probability the pirate is someone who knows what he is doing, and I will know that my best chance is to cooperate. If I then get a demand for a reasonable percentage of my cargo (up to about 50%) then its an easy decision: drop the cargo and get on my way. If the pirate is polite and professional, so much the better.
There's nothing worse then being pulled out of FSD and left sitting there not knowing what's going on. Sometimes it takes quite a bit of effort to get the pirate to state their demands. If I get a "GIVE GOLD PLEEZ", well, the pirate hasn't thought out their strategy, so there's a much better chance of escaping. I might drop a couple of cargo cannisters as a diversion and then boost away, and I stand a reasonable chance of escaping.
If a pirate doesn't hail me, but just starts shooting at me to get the shields down to attach a hatch breaker, well, I'm already racking up a repair bill, so I might as well try to escape. I might not succeed, but hey, its a game, and I tried.
I don't know how other traders react, but I'd be willing to bet that pirates who have done their homework, prepared properly and are able to make the trader believe that dropping a load of cargo is the closest they're going to get to a "win-win" are the pirates who are the most successful. And treating the traders sustainably (not frightening them off to trade in another system) seems eminently sensible.
Sorry for rambling on. I don't Combat Log, by the way.