IMHO I do see the point about tablets.
The majority of the general public want a "computer" for simple stuff - check emails, surf the net, tweet / social hub, watch videos / listen to music, (maybe) simple office stuff. They don't need any heavy computing stuff, they want an entertainment device. They want portability (small size and light weight) and good battery life.
This is why laptops evolve into netbooks (smaller size, slower processors with great battery life for the size and weight, while still able to do the basic tasks including simple office suite).
The tablet seems to the natural progression - you lose the physical keyboard, you further lose weight and reduce the thickness of the device (or use the same space to pack more battery in to make it run longer). True I prefer a physical keyboard over an onscreen keyboard, but an onscreen KB is "adequate" for the most light tasks. Maybe when voice recognition matures we can completely do without the KB (sad day in human history, one more step down from degeneration of handwriting .....).
This argument about having a physical keyboard or not will always be there - some people cannot accept it, others have absolutely no problem.
Another logical progression from netbook into tablets is the mergence of portable multimedia player with portable computing.
Yes current technology can squeeze all these into a smartphone - but most people would not tolerate staring at a tiny screen (eg. < 4 inch) and fumbling with tiny onscreen leyboard buttons all day long (I got used to it, doesn't mean I like it). True there are smartphones with larger screens, but to me they become "too large" to carry around as a cellphone.
To me, the sweet spot for tablets seems to be around 7 to 8 inch screen - 10 inch tablet is too large to carry around for my preference. If I do I'd rather lug around a 10 inch netbook with a physical KB. Anything smaller (eg. 5 inch or smaller) is just too tiring for the eyes with continuous use.
And you are correct - the market is driven by manufacturers: they advertize and brainwash the customers with the idea of tablets ("something new and trendy and different") so that they can push their products. However, the bottom line is that there is also a lot of sense in the evolution of the tablet format.
I agree you may not see many of these in the wild (I only started taking my Galaxy tab out with me on biz trips), but it doesn't mean people are not buying them - I think most people like to use tablets at home, where you have the convenience of "instant access", just like streaming TV, video and music around your house. This again shows the importance of the multimedia function of this new breed of tablets.