If completely stationary, no. If moving, yes, water will drain.
You are taking about the bilge draining and the question is about the live well tank.
The outlet on the transom for my live well tank is below the lake water level. The tank itself is above the lake water level. The tank drains completely when stationary.
Not all tanks are above the water level. Doesn’t matter where the outlet is, only the tank position.