Dear Jerry,
the $N=8$, $d=4$ "non-stringy" supergravity is
- non-perturbatively inconsistent
- unacceptable phenomenologically
Trying to fix either of these things leads one to string/M-theory. See
Two roads from $N=8$ sugra to string theory
http://motls.blogspot.com/2008/07/two-roads-from-n8-sugra-to-string.html
The perturbative inconsistency may be seen in many ways: for example, the supergravity theory has $U(1)$ charges but produces no charged objects with respect to these $U(1)$'s. That's inconsistent because at least a newly formed black hole may confine these electric and magnetic fields and become charged.
The electric and magnetic charges have to be quantized in inverse units, as seen by the Dirac quantization argument. It follows that the noncompact continuous exceptional $E_{7(7)}$ symmetry has to be broken to its discrete subgroup, the U-duality group. There are many ways to choose the lattice of allowed charges. These ways are related by the original continuous symmetry. In decompactification limits, the lightest of these charges (with smallest spacing) may be interpreted as Kaluza-Klein momenta with respect to new dimensions, and one discovers the 7 compactified dimensions of M-theory. It may also be showed that the other charges inevitably have the shape of string/M-theoretical membranes and fivebranes.
There's no doubt today - and since the mid 1990s, in fact - that the supergravity theory is just a perturbative approximation to string/M-theory which is also why the supergravity community has been fully merged with the string/M-theory community. The people realize that they are working on the same theory and they are saying the same things. Ask Michael Duff.
Phenomenology
The maximal supergravity in four dimensions is left-right symmetric, and the high supersymmetry leads to too huge degenerate multiplets where spins differ by as much as $2$. The only acceptable supersymmetry is the minimal one where spins differ by $1/2$. The maximum supersymmetry implies that left-handed neutrinos couldn't exist and for each particle, there would have to be lots of very different superpartners. One couldn't get matter and gauge fields decoupled from gravity etc.
The maximum supersymmetry cannot be broken down to a smaller one by field-theoretical mechanisms - except for an explicit breaking that just destroys all the finiteness virtues of the supergravity. However, it may be broken at the stringy level, by appreciating the extra 6-7 dimensions, and compactifying them differently. The resulting models are compactifications of string/M-theory. They preserve the perturbative finiteness by the added stringy species and they also lead to realistic phenomenology with all types of matter and interactions that we know.
As Joe Polchinski said, all roads lead to string theory. In the case of attempts to overcome limitations of supergravity, the previous sentence is not a slogan but rather an accurate description of the situation.
Cheers
LM