Secure DNS only hides your DNS traffic.
So as the name implies it only secures what you do with DNS not what you do with the information you got from DNS.
"Does DNS over HTTPS hide the name of the sites that I visit?" was in question. So what happens if you only employ DNS security,is it prevents data from being openly visible when the you ask for whatever.com to your DNS server which in most home arrangements if off YOUR network..
Your computer then however takes that response of the IP it resolved to and makes a connection. That connection will be in the form of an IP, and IP addresses can be traced back to the site hosted on them (Often). IN the case of multiple sites on the same IP it can be vague, but say for instance one is adult content and the other is crocheting, etc.... Logical deductions can be made.. Now the data to and from that site will almost assuredly be encrypted. So what you did while on the site, will not be known. Nor will what you asked DNS for, but it does nothing to hide what you ultimately connected to.
See image, packet captures WILL show traffic to and from IP addresses. So with secure DNS you would not have seen my computer asked specifically for facebook.com, but you could see the IP it was connected to belonged to facebook