[C++][Docs] Substrait Usage in Acero

[asfimport]

At the moment, the main ExecNodes are supported in consuming Substriat plans in Acero with basic functionality. There are pending improvements. Also the otherway, the Acero execution plan must be able serialize using Substrait. This feature is currently being implemented. These features must be documented with a set of examples in using Substrait with Acero.

Reporter: Vibhatha Lakmal Abeykoon / @vibhatha

_{Note: This issue was originally created as ARROW-17210. Please see the migration documentation for further details.}

[asfimport]

Apache Arrow JIRA Bot:
This issue was last updated over 90 days ago, which may be an indication it is no longer being actively worked. To better reflect the current state, the issue is being unassigned per project policy. Please feel free to re-take assignment of the issue if it is being actively worked, or if you plan to start that work soon.

[github-actions]

This issue has been marked as stale because it has had no activity in the past 365 days. Please remove the stale label or comment below, or this issue will be closed in 14 days. If this improvement is still desired but has no current owner, please add the 'Status: needs champion' label.