Was John Hinckley the dumbest would be assassin ever?

Did he really think shooting Reagan would impress Jodie Foster and she'd start dating him? And wasn't it obvious to everyone that she was lesbian anyway or did that come later?