Ron Paul has a pretty neat-looking special attack, but it doesn't do enough damage to justify its high MP cost and long casting time. Stick with Yuffie and Barrett.
Presumably they all drowned and/or melted on contact with running water.
Just wait, guys. Ron Paul is simply biding his time, waiting for the perfect moment to launch the rEVOLution. WE STAND READY, DEAR LEADER! JUST TELL US WHEN IT WILL START!