Text this: Low-Frequency Divergence and Quantum Geometry of the Bulk Photovoltaic Effect in Topological Semimetals