[v23.1.x] Add thrashing of old txn sessions to prevent OOM

[vbotbuildovich]

Backport #12477 to branch v23.1.x. Note that this issue was created as a placeholder, since the original PR's commit(s) could not be automatically cherry-picked.
Here are the commands to execute:

git checkout v23.1.x
git checkout -b vbotbuildovich/backport-12477-v23.1.x-390
git cherry-pick -x cdd6481925721ab10f26aedb52d0318038762eca 6e4fce3b81a23f58cf0105fa0afd0ceacfc9a0ea 679baa6179bbac06312636848aca33fd0c87519f 48d85d29c57280d5167889fae3bcaac5e1867336 03d4a0e2798d87bc565b341b944930fcb3fb82e1 b4ed101182bafa92609c6be86e8515c59455fce7 37d745f3a85d85edc324e7739439af62388edbdb dc9b56ec32b1a648b3ea262987de4c5d54f37572 4bf7d351654cbe4bce41a7562bba3b466e44f5ce 1da806427e71f3888dcf03257a3552d1a94978cc b831fd8ad5bf00b43e7a39228ba0f3a02a0c10e2

git push origin vbotbuildovich/backport-12477-v23.1.x-390
gh pr create \
  --title "[v23.1.x] Add thrashing of old txn sessions to prevent OOM" \
  --base "v23.1.x" \
  --label "kind/backport" \
  --head "vbotbuildovich/backport-12477-v23.1.x-390" \
  --draft \
  --repo "redpanda-data/redpanda" \
  --reviewer "dotnwat,bharathv" \
  --milestone "v23.1.x-next" \
  --body "Backport of PR https://github.com/redpanda-data/redpanda/pull/12477 "

[piyushredpanda]

This was merged/done.