Just a couple notes -- Lightroom was designed from the ground up to be a very thorough and often complete "workflow manager" for photographers, meaning that with one integrated interface a photographer often can do all that is needed including printing and outputting for various uses without the need to send all your files to Photoshop. In fact, many of us rearely use Photoshop, just for special needs, but for those we are glad it's there.
Photoshop was not designed that way. It has a browser/organizer, Bridge, that was designed to "catch all" of a variety of Adobe applications for graphics, document design, and photography, and integrate them together to work together. The photoshop editor itself reflects that intent, with an ever-increasing amount of graphics tools that may or may not be useful to a photographer, although if you are a photographer with graphic and/or design needs it can be invaluable.
The Raw processor in Photoshop is a plug-in, a separate dialog but not an integrated part unless you need it. It shares the same engine and tools as Lightroom and has some but not all of the support functions that Lightroom has developed.
Bridge also has many but not all of the organizational tools of Lightroom, although the Lightroom "Library" module is designed to be an integral part of the interface -- you have to hunt more in Bridge to do numerous tasks that are built in with Lightroom.
Just one more thing -- the "abomination" of a histogram in Lightroom needs more clarifying. What the Lightroom histogram actually represents is the wide gamut color space that Lightroom operates in and that includes more of what the camera captures than the sRGB color space that we often work in (and that most of our monitors are close to). This means that if colors in the Lightroom histogram are up against the right side, in sRGB they will be clipped and so not accurately be displayed in a "consumer" monitor or in an image exported for the Web and other sRGB uses. If you understand it, you can work with it in Lightroom, but ACR (and DPP from Canon) both have the ability to switch between sRGB, aRGB and ProPhoto RGB or Wide Gamut in DPP (which will give you the same histogram as LR). The histogram will adapt to your chosen color space so you can adjust accordingly.
So, do you need both? No, you can find tools and workarounds that will give you pretty much all that Lightroom does, although not so much all in one neat efficient package. So it's a question of how much you want that efficient package and what it's worth to you.
You might be well advised to take time to at least learn the basics of Photoshop before leaping into another major application, though. You could certainly try the free trial of LR, but if you do this right away you might find yourself overwhelmed, whereas if you learn to get the most out of CS you will be in a better position to evaluate LR down the road.