As you enter the smuggler’s tunnel for the quest “Northpoint in peril” you will spawn inside the lighthouse. All you need to do is now take the door to the top of the lighthouse.
Enter this door to climb up on top.
You will find the shard behind the wooden screen of the lighthouse.
Sand Kingdom Moons - Super Mario Odyssey Power Moons