Renewable energies will probably survive for a while but eventually it'll be all fusion. In my opinion, the production of fusion energy will be so cheap that it would be more cost effective to just dump the energy, hence the spikes in power consumption can be compensated by running more reactors and dumping the excess.
To put it another way, the same argument you're making could be applied to (say) making computers from vacuum tubes, or balloons out of lead, or any of a myriad of approaches to solving problems that are losers regardless of effort expended. Why are we assuming fusion isn't also similarly a loser?
All that could be true, and fusion could still be hopelessly uncompetitive. The problem is the complexity, difficulty, and size of fusion reactors. Free fuel doesn't make up for that. All the long term beyond-fossil fuel competitors fusion has to beat are also only loosely constrained by fuel availability.
Fusion reactors might be complex and difficult to figure out, but once it has been figured out the free market will inevitably make it cheaper.
Fuel availability is indeed a problem, IIRC the uranium reserves will hold us out for another 200 years before running out. At current energy demands. So realistically more like 100 years. Coal and oil will inevitably run out too. Sun and Wind don't produce a lot of power compared to Fusion when considering the rare earths required for the components. Fusion is just a lot more efficient and energy rich.
Fuel availability is NOT a problem. There is no shortage of sunlight, or wind, or uranium (if used in breeder reactors, and why are fusion reactors, which are breeders, allowed but fission breeders are not?) The 200 year figure for uranium assumes a once-through cycle. In breeders, ores with 50-100x less uranium per unit mass of ore would be usable, because breeder get so much more energy out of each unit of uranium mined.
Oh, and please don't repeat the Rare Earth canard. Solar doesn't use rare earths, and wind doesn't have to. I think you're just repeating talking points you haven't bothered to understand.
It's probably not going to be that cheap, so it will instead replace all that fossil power.
Renewables are also quick to scale out, and low impact to decommission, so there's no loss in keeping on accelerating wind farm deployment.