As an orchestral conductor and piano coach I've had to overcome this to the point where I now enjoy sight-reading - something my younger self could only dream of. Along the way, I've also discovered that it's a completely teachable and learnable skill.
I've compiled a pdf outlining what I've learnt along the way as a child struggling with my personal shame of being a 'bad sight-reader':
The most common psychological blocks to sight-reading
How sight-reading really works - and how it doesn't
The pre-requisites to developing sight-reading
How to practice and develop good sight-reading
Who is this for?
Pianists and musicians of all kinds - classical, jazz, pop and beyond