The most you can accomplish on a PS1 with CD streaming is, roughly, a Crash Bandicoot level[0]. Texture data is relatively bandwidth-heavy - and a single speed drive can only manage 150 Kb/s. So the optimal use case for "showing as much graphical data as possible per second of gameplay" biases towards using load-once textures, then streaming in more geometry with a camera designed to only go forwards: then everything matches the linear access patterns of the CD.

[0] https://all-things-andy-gavin.com/2011/02/04/making-crash-ba...