No good. I have a Wacom tablet (the standard in the graphics industry). I just started up Missile Command out of curiosity and tried my pen. It gets the input, but the cursor just jumps randomly around the screen. When I put the pen down and grab the mouse, it works normally.
I think the system just sees it as another mouse, and the specific graphic apps that can accept pressure input see the pressure data. In non-graphic apps, pressure on the tip equals a mouse click or drag. In order to use the pressure feature of the tablet, the app must be tablet compatible. This used to require a patch that made the app compatible, but in recent years, most apps have this funtionality built-in.
Anyway, the tablet software emulates a mouse in windows, but the output appears garbled in Mame, possibly because its position info is absolute, not relative like a mouse. The tablet it positional--if you place the pen tip on the upper-right corner of the tablet, the pointer goes to the upper right corner of the screen, and if you pick the pen up and touch it down in the lower left corner, the arrow jumps to the lower left corner of the screen. When you move a mouse left, it just goes left. If you pick up the mouse and move it left again, the arrow moves further left, and so on, until it bumps into the edge of the screen. So the input method is different, but I don't know if you could have Mame see it as a separate device. It just fights with the mouse for pointer control just like any other mouse.
It seems like a pretty roundabout way to get another mouse, to write a tablet driver for Mame, then tricking Mame into thinking that your mouse is a tablet...

Since I've never gotten my tab to move separately from my mouse, it doesn't seem like it would work.
I would think that you could more easily do a hardware hack to make the second trackball send impulses to the comp (maybe thru a hacked gamepad), thereby emulating a joystick. It seems to me that I heard about a trackball that did exactly this. Maybe it was the Atari 2600 trackball... not sure.