I actually really like Poet, especially in the context of your family and naming style. To me it doesn’t read as “my child must become a poet” any more than Hunter has to hunt, Archer has to shoot arrows, or Sage has to be wise. Most people quickly separate a name from its literal meaning once it belongs to a real person.
I also think names in this category are becoming more familiar. Francesca Fargo named her daughter Poetry Lucia, so its similar and doesn’t feel shocking once you hear it on a real person. The same thing tends to happen with unusual names in general, they often feel daring until they’re attached to someone, and then they simply become their name, like I knew a girl in school named Tiger.
What stands out to me is that every time you mention Poet, you sound excited by it. You love saying it, love seeing it written, love Poe as a nickname, and you’ve struggled to find another first name that gives you the same feeling. That says a lot.
I also think Poet Wren is lovely. Wren gives that beautiful connection to your other sons name, while Poet feels soft, creative, nature-adjacent and distinctive without being harsh. It fits surprisingly well beside Ocean too, both are evocative names, but they’re different kinds of imagery.
If you want a few other names that seem to fit your style: Peregrine, Cedar, Finch (Fin), Cyan, Rune, March, Grove(r), Thorne, Sonnet (Sonny), Arrow (Ari), Quest, Tale, Ballad, Vale, Basil, Noble, Birch, Flint, Lane.
But honestly, reading all your comments, Poet feels like the one you’re trying to talk yourself out of rather than a name you’re unsure about. And for what it’s worth, I can absolutely imagine a Poet who grows up to be a footballer, engineer, carpenter, scientist or anything else. Once a child arrives, the name tends to become theirs rather than its dictionary definition.