It's an old school playlist management feature from the Amarok Era, it's for when you're thinking "this is the last song I'm listening to, but I do want to finish it". Once that song gets hit in your playlist, it'll automatically stop playback at the end of it.
And by playlist I more mean active queue. Making it sound complex but it's a very intuitive UI if you try it out.
The whole design of Amarok/Clementine is so far ahead of modern players like Spotify, just being able to browse songs off your play list while keeping your playlist visible would be nice, but stuff like "queue as next" vs "queue as last" is awesome. These days Electron UIs confuse me so much I'm not sure what I can even drag and drop.