Is my 904 toast?

It was a hell of a vibration + shaking and made a fairly loud noise I'd never heard before. In second gear only.

Could have been a loss of traction. Go out on the street and do it again and see what happens. If it's a transmission problem, it's already broken. Not like you're gonna hurt it anymore tying to find out what it is.