So then you add different greasy groups to new compounds and screen those. So will be worse, but sometimes some will be better. Then you look at the better ones, like having a nitrile group off the 1' position of the ribose and maybe that started as an amine (I'm making shit up here) and they decided to make it stick further out (IDK).
Anyway, I did some quick looking at it seems like remdesivir is a prodrug that gets modified by other enzymes to become triphosphorylated and then incorporated into the RNA genome of the virus (https://www.nature.com/articles/nature17180/figures/1). So they got super lucky finding it! Check out that paper for the story.
It's all part of ADMET (absorption, distribution, metabolism, excretion and toxicity) optimization. Pharmacokinetics is an important subject, and that's why you can use the "XY shoved activity in vitro" papers only as starting points.
The adenosine bit is attached to a five carbon sugar (pentagon with O at top) which is identical to the sugar it would be attached to in RNA. The next thing along is a phosphate with some oxygens double bonded to it, which is part of the "backbone" of DNA. The stuff attached to that phosphate is nothing like DNA or RNA.
Hope this makes sense and provides a little insight for you :)
What I’m curious about is why this huge group attached to the adenosine-like group is needed. It seems to be rather complex for being a shoe to be thrown into cellular gear. Do you have an idea or pointer into the mode of action of this group?