Question of having different lens

I am often wondering is using prime lens limiting your photo option. like if i get the 24mm lens, then I won't be able to take photo that require zoom. isn't it better to use a zoom lens instead so you can adjust whenever you want?

as I am a little bit new in photographic, I am a bit hesitate should I go with those prime lens.

also another question, lot of people using those legacy manual lens. but won't it make you have to adjust the focus everytime you want to take photo? that's seem like that it become much more difficult to do point and shoot.