I was a little bewildered by the amount of choice when I went down this road as well, so you're not alone! Having said that, if you're mostly working down at only 100-150 MHz, just about anything will do. RG-58 and RG-316 (what you linked) are very popular and widely available choices, so I expect you won't have much trouble finding connectors to suit either. RG-58 has somewhat lower attenuation per meter than RG-316*, but RG-316 is much more flexible. So given your stated desire for flexible cable, and then relatively undemanding electrical nature of your requirements, I'd say that the RG-316 cable you selected is near-ideal.
Make sure that the plugs you buy are suited to the cable you get! There's no such thing as a universal BNC connector, there are BNC connectors
for RG-58 and BNC connectors
for RG-316. Make sure you can find suppliers for appropriate BNC/SMA/RP-SMA connector for your chosen cable before committing to the cable.
* See
this enormous table of figures. In short, up around 2.4-3 GHz, a 60 cm length of RG-316 will have about the same attenuation as RG-58.