The difference is in the type of information it gives you. A wide cone uses a lower frequency (for example 80kHz) to give you a broad view of the area beneath you without specific information.
On the other hand, a narrow cone (for example 200kHz) provides higher accuracy and shows the fish and bottom in detail. It’s ideal if a fish finder uses both when scanning.