Hey,
unfortunately it is not possible to copy data into Sharepoint via ADF directly as you rightly identified that there is no Sharepoint or http connector available in sink.
you would have to use other Azure offering like Logic app or Azure function etc to do the same.