My experience with Hadoop was that it was too complex, too slow, too hyped up. It didn't take long to work out that it wasn't going to replace anyones data warehouse. I doubt whether any data warehouse person would be doubt free by the end of a morning.
Another issue was that a lot of technology gets hyped by people who don't really understand the problem that the inventors of that technology were trying to solve. Or even if the inventors themselves had correctly identified whether problems being solved were symptoms or causes.
Even though RDBMS' have been around for decades I'd be surprised if the majority of non-database people think they are anything other than machines for running SELECT, INSERT, UPDATE, DELETE statements.
Hadoop isn't alone in being a technology for solving a specific data problem but not one that was ever designed for more general problems. Hadoop was designed to help crawl the internet for information available publicly. It was never designed with security in mind, with concurrency or a whole host of other things that are expected of a data warehouse.
HDFS was a good concept but other distributed file systems are available. These days cloud blob storage such as AWS S3 are available and provide scalability and resilience Hadoop can only dream of.
The benefit of Hadoop was that it taught us to think about approaches to data processing in different ways.