Are ecosystems with a lot of water support fewer organisms than ecosystems with little water?

No, just the opposite.

Think of an ocean compared to a desert. Which has more life in it?

Even IN a desert, where is there more life, in the dunes or at the oasis?

Water is necessary for all life, creatures that can survive on minimal water are actually rarer than other forms.