Your videos are good - just watched the viewbotting one to the end, and my attention span for stuff I'm not actively seeking is typically less than 10 secs!
40% is a good number if it's rising, I feel. Mine is over 70%, but my videos are much shorter. I guess what an acceptable retention rate is, all depends on the type and duration of the videos.