I always thought it was based on Captain Picard's iconic facepalm, i.e

https://blog.trekcore.com/wp-content/uploads/2018/04/facepal...