Can an apple pie still taste good without sugar?

Without sugar, no. Without added sugar, absolutely. You could use a sugar substitute, like sucralose, or just precook some apples to bring out their naturally-occuring sweetness.

Organic honey also makes a very good natural sweetening agent and substitute for sugar.