This idiom or expression like phrase means:

An easy target.
An easy victim.

We have to be doing something. Instead, here we are like a sitting duck!!

Compare to:
Moving target.

This idiom or expression like phrase means:

A difficult target to hit.
A difficult situation to figure out.
A changing situation where finding a solution is difficult.

Also see:
Sitting duck.