Solar has value, it generates the most during the day when demand is high, it shaves the top off the demand curve. But it is not reliable. Wind is even less reliable or predictable. You will always need a reliable source to back them up.
So expect your overall generating costs to be higher.
Libertarian/Conservative from a red state of Alabama here: In our southern states solar energy is very plentiful and particularly good since our largest home energy consumption is the A/C (more if it during the day, especially the long hot summer days). So even though there's still a need to supply power during intermittent times (as you correctly point out), the need is less so here in the south (which means we might be able to solve the problems on our own).
And for that I'm looking heavily personally (not into government mandating anything) putting solar onto my rooftop, buying a little bit of battery storage for nighttime, and supplement that with a home hydrogen electrolyzer/storage unit powered by electricity. On the days I get more solar than I use -- it charges the battery and runs the hydrogen electrolyzer. At times I using power without solar -- it'll pull some from battery and after that use the hydrogen gas to generate electricity. All can be done automatically.