I’ll try to explain the 40%, sorry for the parts that you already know.
Electric energy is always produced at the same time (and »place« roughly) as it is consumed. (You can’t pump electricity into some reservoir to be consumed later, you always need a different energy form for storage.)
The problem with volatile sources is that they mostly (more than half) produce energy at the wrong time and/or the wrong place, and at other times produce nothing.
⇒
⇒ Aside: the »place« problem is that you can’t build solar panels and wind turbines just anywhere, and they need a lot of space. E. g. Germany has now the problem that the wind blows much better in the north, but the industry is more in the south. So, you need a lot more/stronger transmission lines. Same for offshore wind: more wind at sea, but you need a lot of cables.
The more wind and solar you already have, the more the good places are already taken.
⇒
⇒ (But at least we already have transmission tech, it is now just a question of materials and effort.)
So, assume that we have enough wind and solar that we can regularly produce 100% of demand from them. You can imagine peaks just touching the demand line at top demand.
(You could imagine more than that, but that would mean overbuilding, which hurts the economics quite badly while not making the end result much better.)
⇒
⇒ Now the volatile supply line has valleys between the peaks. If you integrate over time and place, the supply line covers about 40% of demand in this situation.
That is /very rough/ and depends on a lot of factors, but my point is the same if it were 30% or 60%: where does the rest come from?
- Transmission: as already mentioned, we know how to transmit electric energy, it’s just material and effort. This smoothes out the »place« dimension.
⇒