Second surfboard for a weak paddler

Hi! I am a female, I surf once a week in mostly 2-4 ft waves (C-street in Ventura mostly) and I'm looking to buy my next board. The problem is that I have terrible upper body strength. My technique has improved a lot in the 1.5 years I've been going out regularly and that has helped a lot, but I still don't have great power. I'm also 34, 5'8" and 125lbs, so not a great amount of weight. My current board is 8'6" epoxy, wide, thick, awesome for learning. I've started working on turns etc. I can generally get on waves with this board, the really crumbly ones I struggle with though. I don't know what to get next as this board is (or has already.. hello water logged board!) met the end of its lives. I love long boarding, would love to start walking properly and getting my turns better, plus the waves are usually 2-4ft where I go! BUT I really don't like taking a long board out in anything above 4ft as I struggle to control all that volume... also, I really do dream of being able to go out in bigger waves and get the drop in! I looked at a really nice 9' longboard with a round nose and a bit of rocker, but I'm afraid 9' might be too long for me as soon as the waves are bigger... and what do I get to start moving down to a shortboard if my paddling is a problem? I tried a 6'6" foamy once and I won't lie, it was kinda fun and awesome. Is that good idea though? Also I know that moving down will be a struggle, I'm prepared to go back to sucking for a while to learn it...