Having run things like OpenOffice and JEdit on my N900, I would say the issue is not the pixels but the physical size. It is hard to click on tiny buttons, and hard to see tiny text. It works, and it is useful to be able to do that, but probably only us geeky types would do it. On a tablet, though, with a 7" or larger screen size, it would probably work fine even if the resolution remained the same.