No. The Rocksmith Real Tone Cable requires a 1/4" output jack, which standard acoustic guitars lack. It only works with electric guitars (or acoustic-electrics equipped with a pickup and jack).
For acoustic guitar, you'd need:
The Real Tone Cable is designed for electric instruments only.