You want something with a soft tip and a stout butt.
Around 7ft, some go longer.
Weights are relative to the brand. For example, we use ugly stik tiger rods. Med light. 7ft. You would think med light isn’t enough but the butt end is extremely thick and stout but the med light gives it a super light tip. This could be equivalent to a med heavy or heavy in another brand. We have no trouble getting a big 50+ inch fish in under 5 minutes. 80lb test braid.
I would add that a bass or walleye rod probably isn’t going to cut it. Can they get them in sure but most fish in the 50inch range or smaller shouldn’t take more than 5 minutes to get in. Not until you get to 60 inch fish should it take longer.so make sure the rod can handle the fight. Longest fight in our boat was a 17 minute fight against a 71 inch sturgeon.
It might be easier to take suggestions of rods regular sturgeon chasers use, then research which one you like and fits in your price range. Like I said I use the Ugly Stik Tiger. Our group has about 30 of them. Cost between $60-$70.
Good luck.