To make sure I'm understanding you correctly: you are saying that sites which use alpine will use progressive enhancement, where most of the static content is vanilla html, and then little alpine snippets are used to improve the page (nav bars, widgets, etc). Versus full SPA where all of the content is clientside rendered.
At first, I (incorrectly) thought you were saying that the alpine templates are stored "in the dom", so then google would parse them. For example:
<div> Copyright ©
<span x-text="new Date().getFullYear()"></span>
</div>But, once I figured out you were talking about progressive enhancement, I came back to reality that google will only see "Copyright (C) " and won't see "2023".
Note: I think it can be used for CRUD based GUIs, if paired with "Html over the wire" (rails hotwire, phoenix liveview, laravel livewire), but that's a different point.