Cardano Updates

ci(antithesis): avoid secrets check in global if when undefined

Signed-off-by: Chris Gianelloni <[email protected]>

Co-authored-by: Copilot <[email protected]>

## Description
<!--- Describe your changes -->
- calculate all dangling delegations in CTE
- join some CTEs into one
- add temp memory increase for this query

---------

Co-authored-by: RdLrT <[email protected]>

Wrap connectToLocalNode in try @SomeException and introduce a unified
TxSubmitResult return type with three constructors: TxSubmitSuccess,
TxSubmitFail, and TxSubmitError. Previously, network-level errors (e.g.
BearerClosed) escaped as exceptions; they are now surfaced as TxSubmitError.

Update the cardano-rpc call site to pattern-match on TxSubmitResult
directly, removing the tryAny workaround it used to compensate for this.

chore(linter): add `go-staticcheck` to CI checks

Remove constructor tag verification from getScriptHashFromAddress
and getPubKeyHashFromAddress. The ledger guarantees the correct
credential type in both cases: the validated input is always a
script address, and the beneficiary hash is checked against
txInfoSignatories.

Saves ~360K CPU / ~1.9K MEM.