To sum up, then: rising interest rates – when viewed in isolation – help banks in the medium to long run, but they're a burden in the short term – for smaller banks more than for larger ones.
However, if we look only at interest rates and consider just their direct impact on banks, we would then fail to see the forest for the trees. So let's take a step back and look at the bigger picture.