re-enable source e2e tests

Please create a tracking issue for re-enable tests, otherwise it will be easily forgotten :(

_Originally posted by @skyzh in https://github.com/singularity-data/risingwave-dev/pull/287#pullrequestreview-881231189_