The best and easy way to handle this is by using substitute formula and having two columns here is the explanation below:
Column A5: just put google drive image shareable link e.g.
"https://drive.google.com/open?id=1CfUnvGGdt96irA419HnU0BvRafD4F_os"
Column B5: use the combination of two formula image and substitute like this:
=image(substitute(A5,"open?id","uc?export=download&id"))
Explanation this will convert the google image indirect image file into direct link and give the image outcome as you want it.
Screenshot:
