Welcome @Monte Lin,
The Workflow has existed since 2013, so “finally” doesn’t really apply! It’s also not a very popular Workflow (probably, I don’t have real numbers) because it’s not something people need that often. Plus, it requires weird solutions to get right in that many shells. All that makes it so it’s the right decision for Alfred not to have this natively. Alfred doesn’t load the user’s environment by design, it’s a feature. This is exactly what Workflows are for.
Works for me. Open the debugger, set the log output to “All Information”, perform the failing action, and post the output.