Yeah, ATF is nowhere near as dense as mercury, hence the sucking and losing of fluid on your part- you would need a very tall manometer to keep the ATF fluid in.
On the homemade manometers people talk of using small ID aquarium tubing, something that really throttles the air flow down.