With Explorer you can write applications and sell them. You can not install any components which are not come with Explorer version but you still can use them by creating corresponding objects in run-time instead of using form designer.
As a consequence, with Turbo Explorer use of GLScene and other component-based engines will be not so comfortable as with Professional version.
For non-component based engines and console applications I can't see the difference between Turbo Explorer and Professional.