No one is going to vibe code a Photoshop replacement just like no average smartphone user is going to take prize winning photographs with their phone or directly compete with professional photographs.
What is going to happen is what happened to videographers and photographers and what is happening to record musicians: the medium is going to become more accessible by reducing the cost and skill required to make lower quality items.
Just like random selfies don't need you to be a photographer, neither will the one off random app that only your household uses require you to be a programmer.
Making a music video of a trip doesn't require you to know technical knowledge of video recording nor basic music theory. You click buttons and it is done. It won't win prizes but it will be satisfying for the use case it occupies: a one off low scope purpose.
Making tiny one off apps is definitely going to become a thing among people beyond tech and tech adjacent fields. It won't be code clean, it won't be code reviewed or even code versioned but it will be useful and that's what matters ultimately.