SLS is the thing that launches Orion, which is the capsule with humans inside. SLS isn't capable enough to get that capsule into lunar orbit. Orion also isn't landing by itself though, it just transfers the astronauts to a landing vehicle (SpaceX Starship, currently...), which lands and then starts again.
The thing brought up in that video is that the rendezvous point should probably be in lunar orbit, but isn't.