Note: When I wrote this answer, I assumed, like other signals, that the composite video signal was recorded directly to tape with only the odd quirk of being striped diagonally instead of a continuous timebase. It turns out that that's not true. The color information is actually decoded and re-encoded differently for tape, then decoded again and re-encoded back to the composite standard for playback. So I learned something new this week. See the other answers for more detail.
Original answer is as follows:
VHS video as I understand it is simply a composite (RCA yellow) video signal recorded on magnetic tape, along with a separate analog soundtrack. This signal is divided into 1-frame increments that are stored diagonally across the tape, hence the angled, spinning head if you've ever looked inside a VCR. It's not RF modulated except as defined within the signal itself for color information. Googling "composite video standard" without quotes gives lots of results about how the signal works. Here's a good one from google images:
For black-and-white video, there is no RF modulation at all. Just an instantaneous DC level that gets amplified and sent to the electron gun at the back of a CRT (tube) display. For color, and to maintain B&W-compatibility, the difference from pure white is encoded in two mixed AM waves of the same frequency and different phase compared to the color burst that appears between each line of the picture. This frequency is 3.579545MHz, but it only applies for color video. B&W displays just don't have the bandwidth of their own to respond to that, so they only react to the average level, which is precisely the luminance signal that they always used.
Also to note are the negative-going H and V sync pulses; the only difference is that that V. sync covers an entire line while the H. sync is only a blip between the previous line and the color burst.
In summary, a color composite video signal requires 3.579545MHz, so any equipment that supports it must have at least that much also, but don't be surprised if it's only barely, like maybe 3.7MHz or so.
As a side-note, analog TV broadcast was simply that composite signal on another AM radio wave. That's 2 layers of AM for color. Audio was FM on a different frequency, just like analog radio broadcast, so the TV required two tuners to receive one channel. This is probably why analog TV tuners for computers often include FM radio but not AM radio - the hardware is already there without modification.