Merge bitcoindevkit/bdk#2150: `chain 0.23.x`: Fix assumed canonical tx always being...

Merge bitcoindevkit/bdk#2150: `chain 0.23.x`: Fix assumed canonical tx always being unconfirmed

43850b5569cb22e004652b058ce5d13ca2ccd344 fix(chain): Tx assumed to be canonical will not be forced unconfimred (志宇)

Pull request description:

  ### Description

  Fixes #2088
  Depends on #2148
  Backport of #2110

  ### Changelog notice

  ```md
  Fixed:
  - Previously, assumed-canonical transactions always became unconfirmed even though the transaction may be anchored in the best chain.
  ```

  ### Checklists

  #### All Submissions:

  * [x] I followed the [contribution guidelines](https://github.com/bitcoindevkit/bdk/blob/master/CONTRIBUTING.md)

  #### New Features:

  * [x] I've added tests for the new feature
  * [x] I've added docs for the new feature

  #### Bugfixes:

  * [x] I've added tests to reproduce the issue which are now passing
  * [x] I'm linking the issue being fixed by this PR

ACKs for top commit:
  luisschwab:
    ACK 43850b5569cb22e004652b058ce5d13ca2ccd344
  notmandatory:
    ACK 43850b5569cb22e004652b058ce5d13ca2ccd344

Tree-SHA512: 72fa42111a470e4ab52b92213b54d5f6a1521e4994258a41764b18c141fcbc47d4ff58d9e5cdb5cd4dfae151e80e26b64eefc8e735e6c71768e114cefcc3ef8c