cherry-pick fix(meta): keep failed foreground DDL tables fetchable (#25647) to branch release-2.8

[risingwave-ci]

Cherry picking #25647 onto branch release-2.8,

This PR/issue was created by cherry-pick action from commit 7b1b967.,