I would start by saying that a) I don’t have an ideological problem with nuclear, I have an economic one. While wind, solar, and hydro (and the rest) have been getting cheaper (sometimes drastically so, as in the case of solar) year over year, nuclear has only been getting more expensive. The longer we run the plants, the more problems we learn about and the higher the cost becomes.
And no, I don’t think the SMNR will solve that, if anything I think they will be even more expensive ($/MWh) because they lose the economies of scale within the plant. It’s argued that you’ll get that price down since they can be mass produced and modular, but the 400MW scale currently being made are neither small nor mass produced. Building enough of them to actually take advantage of learning rate effects is a dubious proposition, especially with the market fragmented behind dozens of designs.
Whether nuclear retains a spot for itself remains to be seen and will be dictated (I believe) primary by the cost being brought down faster than the alternatives.
And that alternative (point b) is the modernization of the electrical grid (something that we need to do regardless of the path forward) to create larger electrical grids. The intermittency problem is lessened when large geographical areas share their generation capacity. Similarly with storage (hydro one solution that already exists).