Partially fixes #32661.
Depends on #35433 from which the first 11 commits are added here and will be removed when this PR is undrafted. Only the last 2 commits are specific to this PR.
This is in line with the removal and deprecation of BIP 125 RBF signalling from the codebase.