I was going to discuss the Connection Machine tomorrow, but quick searches aren't turning up anything in-depth for me to summarise.
Here's a link though: http://ed-thelen.org/comp-hist/vs-cm-1-2-5.html
If you have more info, I'll boost!
What I will say is that it sounds like it was essentially a modern GPU built from 1980s hardware.
Computers were nowhere near as powerful back then, CG for movies required supercomputers who's computational power was dwarfed by home computers by the 2000s.