"No longer needed" is probably never going to happen, but IMO needed by fewer companies is inevitable. I see "vibe coding" as an extension to those website builders like Squarespace, definitely not suitable for a large website or a company whose entire business model is software and/or web based services, but good enough that the owner of a small, non-tech company who just happens to need a website or simple app can do it themselves instead of paying someone on Fiverr or something to do it. Unfortunately that means the options for new developers looking for easy experience building jobs that could eventually help them land a better paying position will be even more limited than it is now.