Yes, the force push effect works, but it's a little lame considering it's a figure connected to a tube connected to an air pump disguised as Kamino architecture. I was entrigued by the concept of a rain-soaked Obi-Wan, which is why I bought it.
Regarding the missing tube, check your local home improvement/hardware store. I seem to recall that they have clear plastic tubes of many different dimensions. You just ask an employee to cut to your specifications. Maybe a pet store that carries fish tank paraphernalia, too.