Thanks for the Tableau Public workbook!
Tableau will force the color pallette you choose on the data, regardless of whether or not it makes sense. It's sometimes a little frustrating for a variety of reasons, such as this situation (also highly skewed data, and filtering messing up the color scheme you want, etc.).. but alas, we must live with it.
In this case, if you click on that "Advanced" menu when you click Colors, you can choose what you'd like the Center to be:
If you choose 0, you get something a lot closer to what you see in the "Automatic" chart, where negative is only orange. But alas, shading is different, which is I guess why we have a variety of color option (=
Yes, you guessed it. I did try setting the center to 0. And that's what I was alluding to at the end of my post. The colors do get close if not spot on to the behavior with the automatic palette.
But then the profit legend starts to act incorrectly. Instead of displaying the min and max profit values for its text; the lower text value will incorrectly show $0 as long as there's no negative profits.