Where are those charts from?

You just have to read the video description on youtube to get what you want.

Also Jonathan has an entire website that promotes his materials so that means he is a " Villain" for Pokerstrategy

I hope this will help you :

There are many preflop situations missing (e.g. when there are limpers in front of you) and I would love to dig deeper into this.

There are two types of limpers:

Facing One Tricky Limper
• They may limp with only premium hands, or mostly marginal hands plus a few
premium hands, meaning specific players’ ranges will vary significantly.
• Most will limp/3-bet with only the best hands, but some mix it up.
• Most players are only capable of being in tricky from early position.
• Be inclined to limp behind and see a flop with hands that flop well.
• Be inclined to raise with hands that do not flop well.
• When you get limp/3-bet, fold unless you are getting the correct implied odds.
• Raising for value with the intention of folding if 3-bet is fine if their range
contains many marginal hands.

Facing One Straightforward Limper
• These players usually have junky ranges that do not contain the best hands.
• Raise them with a range similar to your initial preflop raising range.
• You may be able to raise even wider against some players, especially from late
position, because their limping ranges will be incredibly weak.
• You should tend to raise a strong linear range of strong pairs, middle pairs, and
big cards that do not mind being heads-up.
• It is perfectly fine to limp behind with hands that flop well, like small pairs,
weak suited Aces, suited connectors, suited gappers, decent offsuit
connectors.
• If they limp/3-bet, get out of the way unless they are known to be maniacal.
• Most straightforward limpers are straightforward.