To quote the Codex
The return value should be used to determine whether to display a static sidebar. This ensures that your theme will look good even when the Widgets plug-in is not active.
So essentially you can use is to display other content if the user has not activated any widgets in the sidebar.