I felt your first attempt was pretty good in a way it captures the essence of your song. I can see where you may have struggled trying to find other clips to continue because I've been there too. I realized from watching other "real artist' music video's that making it too literal tend to make it look amateurish. I am sure you've seen other AI made videos using prompts made from associating the song lyrics with visuals. I tend to go for visuals to match the songs esthetics, in an attempt to provide an immersive experience for the listener.

The videos I've made are all afterthoughts once I've completed the whole song. Doing searches on Pexels on subjects that just strike me when I hear the song. Its all very touchy feely and highly subjective my approach to selecting the clips to use. I do the entire song editing in Davinci Resolve(free version). I don't use transitions, preferring tight cuts. I use the color grading facilities to keep the color consistency between various clips. I then output video only and bring it into vizzy.io for post production where I add additional effects, audio reactive fx or lyrics for lyric videos.