Partially fixes #32661.
Prerequisite to #35404 and #35405.
All these changes address the points raised in the review of PR #34917 here: #34917#pullrequestreview-4362148900.
Essentially updating the existing wallet functional tests without using the -deprecatedrpc=bip125 and -walletrbf startup options. Instead, these two are added and tested via a singular new wallet_deprecated_rbf.py test that can be removed easily later when these startup options are completely removed from the wallet post deprecation.