There’s only one answer to that as far as I know and it not trivial in part because “from inside the LAN” is nto a completely specified scenario. But if you consider how this works you will see the answer is at some level not complicated, yet may need some diagnostic effort on your part.
Any device you use, in any context has a configured namesever (DNS) that it will use to resolve names. It’s usually provided by the ISP but on my Omnia for example I have kresd acting as the nameserver to all LAN devices. Still, the idea is simple, the DNS that your device is using either has your DDNS name known to it, or not.
So the first question is, what DNS are you using?
From the WAN, you probably have no say in the matter and are using whatever DNS was provided by either the LAN or WAP you’re connected to when you have that experience. That it works though is a very good sign, suggesting that your DDNS updates are working that the IP updates have propogated and reached nameservers across the world … that is the suggestion anyhow.
So, from you LAN, easy enough to test, just take your device and configure its DNS manually to point to sa 8.8.8.8 the open google DNSs or 1.1.1.1 or 208.67.222.222 … quite a few options of globally available nameservers. Try configuring a LAN device to use that and see if it resolves your DDNS name.
On basis of the first observation (that you have access from the WAN) my money says, yes, you’ll have joy. And frankly if that’s you’re only goal, just run with it and leave that DNS configured.
If like many of us, you actually like other features of your default DNS, you may want to diagnose further. Namely on you LAN device, find out what DNS it’s using. Each device will have it’s own way of revealing that, so easiest just to search on-line “How to work out what DNS I’m using on … device?” and you’ll have an answer.
If you’re anything like me, it might just be 192.168.0.1 which is a fairly ordinary place for the gateway, or the Omnia to find itself on your LAN, but again there is no universal answer, depends on your LAN configuration.
Either way, once you work out what that DNS is you can ask why it’s not resolving the name, if you know it’s kresd, there are some diagnostics you can do, and folk here can help you with that if it comes to it (I may be able to as I’ve had to diagnose a few kresd issues in past).
Of course if you’re on a VPN, you may find that your LAN device is using another DNS. From its IP you can find who owns it and runs it, just use an on-line tool for the job (plenty about). And you may find it’s the nameserver your VPN operates. In which case, time to contact them and ask them why their nameserver is not resolving your DDNS name.
Could be something as simple and banal as, that they choose to block DDNS names in general or those with your DDNS name pattern … Service providers have a long history fo trying to clamp down on spam and phishing sites by various means including blacklisting of domains and even TLDs etc.