>Is In-Memory OLTP compatible with SQL express or not?

Yes, as [documented][1], it is.

>Am I doing something wrong?

Yes.

>Could not process the operation. Always On Availability Groups replica manager is disabled on this instance of SQL Server. Enable Always On Availability Groups, by using the SQL Server Configuration Manager. Then, restart the SQL Server service, and retry the currently operation. For information about how to enable and disable Always On Availability Groups, see SQL Server Books Online.

This is because you're running RTM and didn't apply any patches from the last ~3 years. This was [fixed in CU1][2], the very first cumulative update. Once applied (CU14 is the latest at time of writing) you won't have this issue. I hope this imparts the importance of applying patches.

> but when executing it [...] I get the following error [...]

Your execution is incorrect based on your supplied example. Your example has `@ConnectionID = N'1234'` as a parameter, yet the natively compiled stored procedure has the parameter of `@CID` which means you should receive an error about expected parameters are missing. Most likely, due to not patching, it's having an issue that is already fixed. I could not get my batch killed from the server side such as yours was, though I also didn't try very hard given it's incorrect on many levels which when fixed shouldn't have any issues.


>Memory optimized tables are all about throwing lots and lots and lots of memory on your SQL Server.

That's one use case, if you're running into hot paths on locking and latching. Most of these aren't large tables, but smaller ones that are frequently updated or used by multiple concurrent connections, such as the session state in asp.net, however there are other uses such as shock absorbing for loading data (though I agree with the original comment of this scenario isn't very useful for Express edition), having tables with no logging (You don't care about the data, it doesn't' need to be recovered but needs to be available), etc.

> [...]the search continues for a suitable "in-memory" store that can run natively on Windows [...]

I didn't see anything that specifies the absolute need for an entirely in-memory relational database engine. 


  [1]: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16#scale-limits
  [2]: https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/cumulativeupdate1#1993393