One issue with SVD is its significant time complexity compared to, for example, the Discrete Cosine Transform used in JPEG
In data science most traditional usecases for SVD are superceded by other algorithms (UMAP is especially popular these days).
Don't get me wrong -- they're great tools. Especially OLS for analysis has this whole framework for understanding errors you will not get in models fit using maximum likelihood methods.
But as a final usecase for a product there's generally better out there.
In computational science and engineering, there are many applications in which the SVD is a very reasonable and good choice. Some examples: fast direct solvers for integral equations, model order reduction, solving inverse problems, etc.