Yes, I believe so.
We've just passed the peak of inflated expectations on the technology hype curve, and the comments on HN reflect this.
But in general -
Do people manually deploy MySQL, Postgres, or MariaDB on EC2 servers? No, (most) people use RDS. The servers are still there, but the management is less.
Do people manually deploy RabbitMQ? No, (most) people use SQS.
Cloud providers have been working out of the same playbook for years - provide low-level compute, watch what people build, and create managed services which solve common use cases. Developers love these services, because it's less infrastructure to be on call for, and they can build products faster.
Lambda and Serverless represents the inevitable conclusion of the natural evolution of the cloud. Parts of it are still painful, but undoubtably it's getting easier and more capable.