mRNA vaccines need a target, and if there is a target, there are several approaches that already do this (anti-body drug conjugates), and sometimes work, sometimes doesn't.
I don't think anybody thinks it "didn't work out". It's still actively ongoing: