The TCC is locked on. This results in pretty much the same experience you might have with a clutch if you left it in gear when stopping or tried to start out in the wrong gear. The TCC locks on because the solenoid gets stuck. This isn't the end for the tranny, but you should plan on a rebuild sooner rather than later. I've gone through this with three vans, all '99s.
Do a search over on the Olds silhouette forum and the Pontiac transport, as well as here. You should find many, many posts from myself and many others detailing this issue as its pretty well known for the vans from '99 thru 2003. The other issues you mention are not related.
Change the up stream O2 sensor, and remove and disassemble the MAF sensor to clean it. These jobs are also described in older posts. The MAF is pricey--don't replace it unless its burned out, they are pretty easy to take apart and clean.
John